Solved: Linked Table Manager

[tkaplan]

I have a database that is really just a bunch of reports based off of one excel sheet. I am using the excel sheet as a linked table.
My problem is that there is going to be a number of copies of this database in use, and i want the user to be able to say where this excel sheet is located, but not every time the database starts up, only when they change location.

the database is not opening up with the database window displaying so i cant teach them how to go to the properties and linked table manager.

what can i do that will detect if the database cant find the table, the linked table manager will open up automatically?

[matthewspatrick]

Not quite what you asked for, but couldn't you just tell people to hit F11 to unhide the database window?

:devil:

[geekgirlau]

Man, that would really open the floodgates! I don't think you want your users to get into the back end in order to get to one little function!

Application.DoCmd.RunCommand acCmdLinkedTableManager

[tkaplan]

Thank you. That's what i was looking for.