Connecting to SQL Server

D

DevalilaJohn

I built an Access 2003 front end to one of our SQL Server databases. The
tables and views that are used are accessed as linked tables. I asked a
colleague who has no ODBC connections defined to test the ap. (When I asked
I didn't realize that there were no connectors defined).

Everything worked perfectly. That leads me to ask, does Access hold the
data needed to create the ODBC connection inside the database? If not, can
anyone shed a little light on why everything worked?

Thanks for your help,

John
 
S

Sylvain Lafontaine

Open one of the linked table in design mode, then choose Properties from the
contextual menu (right click): the Description property will show you the
connection string used for this table.
 
Top