Access Sql Server connection

  • Thread starter Thread starter AccessUser
  • Start date Start date
A

AccessUser

Is it possible to use Access front end Sql Server backend
without the data project. If so where do I find info on
the procedure to set up the configuration.

TIA
SteveAlb
 
Yes. You can create a ODBC DSN (Data Source Name) and then link the SQL
Tables to your Access MDB file using the DSN.

Check Windows Help, Access Help or your Access book on ODBC.
 
Thanks, for the help.
-----Original Message-----
Yes. You can create a ODBC DSN (Data Source Name) and then link the SQL
Tables to your Access MDB file using the DSN.

Check Windows Help, Access Help or your Access book on ODBC.

--
HTH
Van T. Dinh
MVP (Access)






.
Click to expand...
 
Back
Top