MS Access Forms , SQL Database

[whitetiger]

Hi,

I was given a set of mdb files where the access forms were linked to SQL server tables. How do I find out the name of the SQL database the forms are linked to?

thanks

 

[Sergeant]

On the access file menu, select "Connection". There you will see the server and db name.

 

[whitetiger]

Thank you very much. I am a complete newbie to Access. I am using MS Access 2003. In the access file menu I can see only the following

New
Open
Get external data
close

Save
Save As
Backup Database
export
file search

page setup
print preview
print

send to
database properties

I am unable to find the db and server name even in the database properties.

Thanks

 

[Pat Hartman]

If you open the linked tables manager, you will be able to see the connection string for each table. If it is too wide to see in that small form, unhide the MSys tables (Tools/Options/View/Show system objects). Open the table and scroll down to your linked tables.

You will see the DSN if that is how you linked the tables. You can then open the DataSources (ODBC) dialog from the Administrative menu (off the Control Panel on my system). The DSN will tell you the database name.

 

[Sergeant]

Sorry for misguiding you there, it was late, and I didn't notice that you said ".mdb" files. What I posted applies to an ".adp" file, or Access Data Project.

 

[whitetiger]

Hi,

Thank you very much.

I have 6 .mdb files.

The first 5 are linked to the 6th mdb file and the tables in these files point to the 6th mdb file in the Linked table Manager.

There is only one table in the 6th mdb file and this one points to another mdb file which I have no clue of and am not able to locate it. SO does this mean the data is not on the sql server?

thanks

 

[Pat Hartman]

SO does this mean the data is not on the sql server?

If the connection string in the linked tables manager shows an .mdb, the table is Jet. It is not SQL Server. Access databases cannot link to linked tables. What that means is that the link is always directly to the source of the data. You can tell the type of source database visually by the icon used in the tables section of the database manager. Linked Jet tables have a dark arrow next to them. Linked ODBC tables have a globe next to them. Linked spreadsheets have a little Excel icon next to them, etc.