Connecting to SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting to SQL Server DB in Windows 7 1
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
SQL Server connection 17
Does Microsoft recommend databases or projects to connect to SQL s 1
1 SQL Server/3 Db's to connect to 2
What are the steps to fix damaged MDF files in SQL Server? 0
Bulk Change ODBC Link 5
Linking to mdf SQL Server Express database 12

Back
Top