Linking MS Access table with SQL

[raj08536]

Hi Gurus,

I have been trying to link SQL tables thru creating DSN in my pc. It is perfectly fine till I use the MS Access table from my PC but other users can't run this database from their pc.

Is there any easy way to link MS Access table with SQL Server?

 

[Joe4]

I think you may need to physically set up the same connection on the other computers as well (this is what I have had to do when setting up an ODBC connection from our SQL server to our Access applications).

 

[raj08536]

Hi Joe

Following is my link properties.
Can I change DBQ path? Right now it is refering to my local drive and therefore, it is not shared by others. What is DBQ?

ODBC;DSN=PRD;DBQ=C:\Program Files\Khalix\Ontprd\cache\;CODEPAGE=1252;;TABLE=D0_HIER

 

[Joe4]

Are you saying the databases, or at least some of the tables are on your computer's hard drive? I think you'll need to move it to the network if you want others to be able to access it.

Here is how I set up my ODBC connections:

1. Go to Control Panel
2. Go to Administrative Tools
3. Go to Data Sources (ODBC)
4. Go to the System DSN tab
5. Click the Add button
6. Select the SQL Server option, then go through the Wizard.

I do that on each and every computer that is going to use this database.