Which backend are tables linked to? (2000, 2002)

Topic

New Reply

We have a database that is split into a front end and back end. The back end is housed on one computer and that user also has a front end on the same computer. Other people who use the database have the front end on their local machine and it connects to the back end on her machine through the network. We have been using this system and, in fact, the same files, for several years.

Suddenly, updates that I make through my front end are NOT showing up on the backend, and updates that the primary user is making through her front end do not show up when I open my front end!

In order to trouble shoot, I first wanted to see where the linked tables in my front end and her front end were pointing. So my first question (and maybe this will lead us to the ultimate solution) is how do I tell where they are pointing? I thought the properties of the linked table would show it, but it does not seem to.

Please advise.

Thank you,
-cynthia

Reply | Quote

Replies

You can use Tools | Database Utilities | Linked Table Manager to see which database each linked table is used to.
Or open a linked table in design view. Access will protest, click Yes anyway.
Activate the Properties window. The Description property will contain DATABASE= followed by the path and filename of the backend.

Reply | Quote

I am sorry I had made post in a wrong thread!

Reply | Quote

Organizer (who asked the question originally) wanted to verify which database the tables were linked to. If you already know, that’s not necessary.

Reply | Quote

Thank you Hans! It’s been too long since I played with the linked tables, I guess.
I’m away from that computer now but will try that when I get back later today and expect that it will lead us to the answer to the problem.

-cynthia

Reply | Quote