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
examples:
http://able-consulting.com/ADO_Conn.htm
http://www.connectionstrings.com