Topics Search

Linked Table Manager

Linked Table Manager
Views: 29
When I select Linked Table Manager from the Tools --> Database Utilities menu option, Access crashes. At first this happened with a database that I copied and put into a new location. Thinking that it might have something to do with the existing links I tried it with a newly created blank database. Same problem. Before Access crashes it looks like it's trying to install something. Am I missing some add-in or installation option from this particular computer maybe ? By the way this is a Citrix server that this problem is occuring on.
Sponsored Links:

More topics


Linked table manager in Access 2010

I am trying to find the linked table manager is access 2010. I found the following instructions for 2003:

On the Tools menu, point to Database Utilities, and then click Linked Table Manager.

In Access 2010 this path is not available. Where can I find this utility

Linked Table Manager Missing

I migrated a 2003 Access app to 2010. However, now when I click on Linked Table Manager nothing happens. Needless to say I can't link to my back end file with all the tables in it.

New table in be missing in Linked Table Manager

I am working in Access 2007.

I added a table in the be and now need to link it to the fe. When I launch the Linked Table Manager, it doesn't show up in the list. Am I missing a step?

How to locate linked tables automatically.

I have an MS Access database that has a linked table. For various reasons the location where the database and linked table is stored changes. Is there a way to store the linked table so thatI don't have to go in and update the location in the linked table manager? Like can the linked table be in the same folder as the accde file and it find the links?

can't save password in linked table manager

I'm use Access 2010. I have a problem can't figure out how to save the password in linked table manager 2010. My users are asked to reenter the password every time they open the application.

The 2003 Linked Table Manager had a "Save Password" check box, but it is missing from the 2010 version.

LockNavigationPane Action Disables Linked Table Manager

The title pretty much says it all. I am attempting to lock the navigation pane in order to keep users from accessing certain objects so I have an AutoExec macro that disables certain categories and then sets the LockNavigationPane action to true. However, I've noticed that as soon as the macro runs Access grays out the Linked Table Manager. I've confirmed it is the LockNavigationPane action that causes this by running just that one action in the macro and, sure enough, no Linked Table Manager.

This doens't make sense to me, and google hasn't been any help so far. Has anyone encountered this or found a way around it

Using 2010 accde with an earlier version

I have a database program created in 2010. with the exception of the Linked Table Manager. The program I have will use 5 databases in the setup process.

It will go to several different sites. That is why I need to use the Linked Table Manager. All the networks are going to be different. Added tothat, there will probably be different versions of Access.

Here is what I think I read on a web page I was referred to.

You can save the databases as accdr files. If they have a full version of Access on their computer, my program will open as the runtime version. First, is that true? Second, if that is true, I believe the Linked Table Manager will not work. Is that true?

Next, will the accde only work with 2010?

Linked Table Manager - No "Save PW"

I recently upgraded from Access 2003 to 2010. except I can't figure out how to store ODBC / MySQL linked DB passwords locally. My users are asked to reenter thepassword every time they open the application.

The 2003 Linked Table Manager had a "Save Password" check box, but it is missing from the 2010 version.

Trouble with split database

I added a new table to my frontend database, forgetting that it was split. I then copied the table into my backend database and tried to use the Linked Table Manager to refresh the links. I've had trouble with the Linked Table Manager before, as it never seems to work as expected.

I was never able to get the tables linked, so eventually the only thing I could see to do was try resplitting the database using the Wizard. After all, This worked really smoothly, except it apparently allowed me to effortlessly wipe out all the data in my backend database. If nothing else, I want to post a warning to others that this thing is a menace.

My next step was to restore my backend from yesterday's backup by copying it over the old corrupted backend, and using the Linked Table Manager to refresh the links. Maybe it wasn't necessary to refresh the links, but my applications seems to be working again.

I still don't know how to add the new table to my backend database. This is another subject not addressed in any of my reference books. And now, the table is missing from the frontend too, though it is still listed as an object. When I try to open it, I get the error message that the Access db engine cannot find the input table.

Linked Table to Exchange Public Folder Mail items

We have created a simple database in order to managed a small team working on a help desk.

A critical way this operates is by having a mail enabled public folder in exchange. When we create the linked table in the Access Database for one user the linked table pulls in the mail items and we are able to view the items in a form view to carry out actions without issues.

We have a problem though when this database is shared and opened by another user, as the linked table is static to the user it was setup with. A second user receives and error referring to MAPI information not available. I know why this is as when I look at the Linked table manager I see the local path to a temp file on the originals users PC.

Is there a way I can create the linked table to the exchange public folder in a way that allows us to share the database with multiple users? Does the linked table manager have to link through Outlook or can it be done in the back ground with stored credentials