By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,190 Members | 1,375 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,190 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?


Aug 11 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
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!

Sep 3 '06 #2

Post your reply

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