Linking MS Access table with SQL

raj08536

Active Member
Joined
Aug 16, 2007
Messages
250
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?
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,916
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Aug 16, 2007
Messages
250
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,916
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,329
Members
414,055
Latest member
mcarduner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top