Why is Linked Table Manager not available when database is moved to another machine?

[stonward]

Good day All,

I've made a very simple hardware tracking system that the company I work for now want to roll out company wide (gulp). I'm using Access 2010 (I'm used to 2007) and a 64bit machine; I've split the database, but when I install the frontend on another PC the linked table manager is greyed out.

Thing is, even when I try to install an unsplit version with the tables present - the linked manager is still not available for me to point the front to the shared tables.

Essentially I don't want the front end users to have access to the nav bar (so I turn it off in Options), or the ribbon (so I turn that off when my first form opens, since the HideTheRibbon XML never seems to work!).

I need to sort this - any ideas?

Thanks again guys,

Stonward

[Seth Schrock]

If all you are wanting is a way to link the FE to the BE, then you can do it through code. Here is an article that describes the code: Relinking ODBC Tables using VBA. While the article says it is for ODBC tables, it also works for an Access BE. What I did when I used it was to test if one of the linked tables was connected by opening a recordset and then see if I could do a MoveLast/MoveFirst. If it failed, then I knew that the link was broken and I would display a form asking for the location of the BE. The location was then passed to the code that relinked the tables.

[stonward]

Seth,

That's brilliant - wish I'd thought of it. Will try it now and let you know. Thanks for the reply,

Stonward

[NeoPa]

Seth beat me to the punch with the link :-)

However - if a PC doesn't allow Linked Table Manager to run then it may be due to that option not being included when Access was installed.

[Seth Schrock]

I didn't know that it was an option to include linked table manager. I learn new things everyday.

[NeoPa]

I can't say for sure that it is TBF. I'm pretty sure I've come across situations where it isn't available though. This may be due to other software or libraries being, or not being, available. I'm just not sure on that point. There are certainly times when it isn't available though.