I have an Access system that uses linked tables to store the data separately from the system design & code. I am trying to implement a text box to display the location of the database that the system is currently linked to to make sure I am using the right data.
I am using the following expression which works fine in Access 2000, but not in 2003. Can someone please help me to update this to work in 2003?
=currentdb.tabledefs("table1").[Connect]
Thanks
Geoff