I am having trouble getting the properties of a table. I have an
Access.mdb front-end with the data tables linked from a back-end
access.mdb file. My users do not always have the linked file on the
same drive or folder. I want to find the path to the linked back-end
tables. (They are all in the same file.) I notice the tables have the
path in the description property of the table. I don't know how to
get that property in VBA so I can then copy the file to a string
variable to be able to back it up from the front end program when they
exit the switchboard. If it were a form that would be easy: forms!
formname.property. I am using Access 2007 but have not yet converted
the program files to .accdb. Any help will be appreciated. I am just
not very experienced yet.

Bob B.

"Bob" <beaudet (AT) usc (DOT) edu> wrote

You'll find what you want in the tabledef's connect property:

Debug.Print CurrentDb.TableDefs("MyTable").Connect

Replace MyTable with the name of your table. Switch to the VBA editor
(Ctrl-G) and look in the immediate window.

On Dec 7, 5:12*pm, "Stuart McCall" <smcc... (AT) myunrealbox (DOT) com> wrote:
Stuart,

Thanks. That worked like a charm until I started getting "permission
denied" for no explained reason.

Bob