By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Displaying the location of a linked database table in Access 2003

P: 1
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
Aug 11 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,
Can you try withot the brackets of Connect?

If it does'nt work you can try using only the index of the respective table instaed the name!

And sometimes it's better to set the database to a variable and then use the variable with the statement!

But it have to work!

TableDefs(intloop).Connect
Sep 3 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.