I am trying to access data in an Access Database using OLEDB. I am not sure I understand how this works. Once I establish a connection can I open multiple views using that connection, or do I have to establish a connection for each view that I open. I am using the following form:

lnConnectionStr="Driver={Microsoft Access Driver (*.mdb)} Dbq=path and mdb name Uid=Admin Pwd="

If that succeeds can I then open multiple tables using this format:
LnTable1=SQLSTRINGCONNECT(lnConnectionStr)
LnTable2=SQLSTRINGCONNECT(lnConnectionStr)
r=SQLEXEC(lnTable1,"some sql stmt","tablename")
s=SQLEXEC(lnTable2,"some sql stmt","tablename")

Thanks for any and all help!