ODBC connections on multiple computers

[grades]

Hi,
In my database, I have 2 ODBC connections to a SQL database to pull data each month. Am I able to set these up so that the end users will not be required to set up the ODBC data source? I've checked the box to save the pwd on the link in Access, but it still only works from my computer (machine data source).
Hopefully this is a simple question, I apologize if my explanation is vague.
Thanks.

 

[GohDiamond]

You should have a DSN on each workstation which links to the SQL Server for best results. You can't link to a linked table but you might be able to use import to bring in ODBC Table Links from another MDB if they show up in the list.

As for the machine data source, when you get to the Select Data Source dialog box then you see the MACHINE DATA SOURCE tab. Click on it and READ what it says in the information at the bottom of the box: A Machine Data Source is specific to this machine, and cannot be shared.....

Cheers!
Goh

 

[grades]

You should have a DSN on each workstation which links to the SQL Server for best results. You can't link to a linked table but you might be able to use import to bring in ODBC Table Links from another MDB if they show up in the list.

As for the machine data source, when you get to the Select Data Source dialog box then you see the MACHINE DATA SOURCE tab. Click on it and READ what it says in the information at the bottom of the box: A Machine Data Source is specific to this machine, and cannot be shared.....

Cheers!
Goh

Yes, I know it's specific to the machine. Not being very familiar with this process I didn't know how to "share" a connection.

Anyways, I set up a file DSN and put it on the network, works well.
Thanks.

 

[Galaxiom]

The other alternative is DSN-less connection. This has the connection string in the Connect property of the table.