How does a linked ODBC table work on a shared Access file

[dcol]

Hello

Using Access 2007

I have inherited an access database and can't quite figure out how the ODBC side of it is working


The file sits in a shared location
An individual can open the accde file that has been locked such structural developments cannot be made
I hen have a development version that can be amended

So, the database comprises of a number of ODBC links to a SQL server instance
When I look at these ODBC connections, I can't quite see how it works as I do not have the appropriate ODBC data source set up on my machine
It has to be holding this information somewhere - but where?

Now, I've created a new table on my SQL instance
The only way I can add this as a linked table, is set up a new User DSN on my local machine and use that
This does not work on another individuals machine though
Also, it looks different
If I hover over the linked tables, my original ones have: ODBC;Driver={SQL Server};Server=<My Server>; Database=<My Database>; Uid=<My Account>;Pwd=<My Password>;;TABLE=<My Table>
The new one has (after creating a User DSN called SQL Server): ODBC;DSN = SQL Server; Description = SQL Server; APP=2007 Microsoft Office System; DATABASE=<My Database>; TABLE=<My Table>

In addition, I cannot edit any of the existing ODBC links - tried Linked Table Manager and it comes up with ODBC--call failed

How do ODBC links work?

I just need to understand, how I could point a link to another database or server if needed and how do I set up new linked tables that work for everybody


Thanks

Damian.

[ItsMe]

I posted some info in your other thread you started regarding DSN-Less connections.
https://www.accessforums.net/access/...ses-57137.html