Linked Table Problem

[jkfeagle]

Can anyone tell me why none of my lnked tables are showing up in the linked table manager screen? The database functions fine but I need to change the location of the back end and can't get the tables to show up in the linked table screen. Help!!!!!

 

[MSAccessRookie]

Open your database window, go to the tables section, and look at your table names. If they are linked tables, they will have a BLUE arrow to the left of the icon to the left of the name. If not, you will only see the icon. The Access icon looks like a small datasheet.

 

[jkfeagle]

I know quite a number of the tables are linked. (The arrows are there although on my computer they are black) My company has used this database that I created for several years with no problem and as I said it is functioning fine so I know it sees the linked tables. They are just not showing up in the linked table list. Wierd.

 

[MSAccessRookie]

I know quite a number of the tables are linked. (The arrows are there although on my computer they are black) My company has used this database that I created for several years with no problem and as I said it is functioning fine so I know it sees the linked tables. They are just not showing up in the linked table list. Wierd.

By "the linked table list", do you mean the list that appears when you right click a table name and select "Linked Table Manager", or is there another list?

 

[jkfeagle]

Yes. You can get to it that way or through the Tools, Dabase Utilities menu items.

 

[MSAccessRookie]

Yes. You can get to it that way or through the Tools, Dabase Utilities menu items.

And using that method to update the linked tables is not helpful in resolving the problem?

 

[jkfeagle]

In both cases, the screen where you are supposed to select the tables you want to update does not have any table listed but I know for a fact there are linked tables in the database.

 

[MSAccessRookie]

In both cases, the screen where you are supposed to select the tables you want to update does not have any table listed but I know for a fact there are linked tables in the database.

I will assume two things are true:

1. That you are pointing at one of the linked tables. if you are right clicking (you might want to verify that this fails the same way if you already have not).
2. That you have already taken the step of "Compact and Repair".

Since I have never seen anything like this happen before when there were linked tables, I have no further guesses at this time. Hope you can resolve the issue.

 

[jkfeagle]

Anybody else?

 

[jkfeagle]

Any ideas from any others out there?

 

[Banana]

To what are the tables linked to? Access back-end? A RDBMS backend? A CVS file?

Also, can you open the table directly (e.g. double click on a table in database windows and open up a datasheet)?

 

[jkfeagle]

They are linked to an Access back end. What I need to do is update the location of the back end but I can't seem to get it to show the linked tables in the first place.

 

[Banana]

In such cases where totally unexplained, unexpected and downright bizarre problem appears, I would create a new blank database, turn off the AutoCorrect, then import everything from the old database and see if the new database runs correctly.

HTH.

 

[gemma-the-husky]

what version of Access are you using

After A97, just hover over the linked file, and a popup/tool tip will show you the true location of the backend database

alternatively

msgbox(currentdb.tabledefs("A_Table").connect) (change the table name to suit) will show you the connection string, which includes the path also