And why you are talking about OLEDB? In this sample you are using an ODBC connection.

>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")