Calvin,
You only need one connection if all your tables and views are in the same MDB:
lnConnection = SQLSTRINGCONNECT(lnConnectionStr)
SQLEXEC(lnConnection ,"some sql stmt","tablename")
SQLEXEC(lnConnection ,"some sql stmt","tablename")
>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!
Daniel