What if the PC never had Access installed?
I am using a DNSless connection. According to the MSFT knowledge base article the user adds the Access table to the ODBC Administrator.
Thanks!
>Hi David.
>
>>How can I programmatically create a ODBC Data Source for Access?
>
>I'm with Sergey on this -- use a DSNless connection instead:
lnHandle = sqlstringconnect('driver=Microsoft Access Driver (*.mdb);database=<i><b>path and name of the mdb file</b></i>')
Doug