Mary chipman 2012-02-28 09:34:14
Take a look at the DSN you’re using — it’s probably set to integrated
security (Windows authentication). You’d be better off dynamically
linking at runtime in code, supplying your user ID and password in the
connection string for a DAO tabledef object, rather than using a DSN.
Take a look at the following resources for ODBC connection string
Microsoft Access Developer’s Guide to SQL Server