Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Using Access to connect to SQL via ODBC
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 28th February 11:34
mary chipman
External User
Posts: 1
Default Using Access to connect to SQL via ODBC

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

-- Mary
Microsoft Access Developer's Guide to SQL Server
  Reply With Quote

  sponsored links


Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -