Linked Table Manager

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:

Related 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


How to get a new table in BE to link
I have added a new table to my BE but I can not get the table to show as being Linked.
Linked Table Manager doesn't seem to do anything. All tables show as Table: Linked Access except the one new one which just shows as Table

Appreciate any advice.


Microsoft Critical Security Update Broke ACCESS
Our pc's updated Win 7 with Critical Security Updates last night and now databases are broke.

Specifically, the Linked Table manager Wizard will not run.

To recreate the problem, create a new database, make a simple table, Create another empty database and link to the table in the first DB.
Then try to use the Linked Table manager. It throws several errors of interest


Linked Table Manager - Save Password Option in 2010
I recently upgraded from Access 2003 to 2010. I like the new version, except I can't figure out how to store ODBC / MySQL linked DB passwords locally. 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.


Link SQL Database to new Access front end
I have an old database that was running on Access 2000-2003 that had one table linked to the SQL server. The main part that I needed the sql server for was the OLE data attached to a individual documents.

Now I have updated the database into a 2007-2010 version, reports, queries and macros. The one main table that is on the sql server I only added two new fields which is to become the _local.

My problem is do I need to upsize to "use database" to attach it to the sql table, or the linked table manager? The linked table manager is greyed out and I have not had to use it before, so I am unfamiliar with it.


Linked in Table
We have an access database which was created ages ago and the creator no longer works here.

It is one mdb (Unit.mdb) with a linked in table to another mdb (UnitBE.mdb), however if we move the linked in table it will then fail (cannot find .\UnitBE.mdb). However I cannot find out how to amend the linked in table path.

The "Linked in table" manager is greyed out


Using Linked Table Manager --Can't get it work
I have used a split Access97 DB for years, with no problems. In preparing for some computer moves, an office person moved the backend of the database and broke the link. We have been unable to get the link re-established. When bringing up the linked table manager, the front end file does not show as a file option--only one DB that I do not need to link to. I have both saved to a USB flash drive for now. When trying to open the front end, it gives the error message that the path is invalid, which of course it is. The front end is password protected, but we know the password, so that is no problem. I have changed PCs over the years and have upgraded the PC that the DB resides on, with no problems until now.

What am I probably doing wrong? Why will not the front end show in the Linked Table Manager? What should I do next? This is a very important database to the office


Change the location of the database connection
I am using link_tables which are connected to a database in a seperate location.

(if necessary) I want to activate the Linked Table Manager of Access and change the location of the database connection of Access's default database Connection.

I tried but couldn,t find any reference to hot to call Link Table Manager programmatically.

1- How can I call Linked Table Manager ?
2- Assuming that they have same tables, is there a way to change connection programmatically from Database file to ODBC connection and vise versa.


Updating linked tables after conversion
I've recently upgraded a 2003 database to 2007. When I try to update the linked tables using the linked tables manager it shows the tables in the old .mdb file. When I select the new .accdb file and then try to start the update it gives the following error message: "The Microsoft Access Database engine cannot find the input table or query named 'table name'. Make sure it exists and the name is spelled correctly." All of the table names in the link manager show the .mdb file


Linked table manager error
I have created a system DSN using the Data sources in control panel to use the data source in my access database.The data source is Sql server

When I refresh all the tables using linked table manager I get the following error

The Microsoft Jet database engine could not find the object dbO_xxxxx
Make sure the Object exists and that you spellits name and the path name correctly


ODBC error with Linked Table Manager
I am trying to learn how to relink linked tables in my access database. I can easily create linked tables with no problem. I can run the "move to SQL server" wizzard with no problem.

I assume that I use the "Linked table Manager" to do this. I check the tables I want to update and it simply returns a links refreshed message.
So, I check the "always ask for new location box" which I assume is suppose to ask me if I want to connect to a different database. I get an "ODBC error". So why does this happen?

I used a DSN file to create the linked tables. Then I tried a DSN system connection. It still fails. So what DSN connection is used when the "ask for new location" is checked.