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

Please help! You do not have excluisve access to the database at this time

P: n/a
I keep getting this error when manipulating tabledefs collection
members. I have seen many postings about this, but nothing fits exactly
what I am doing, or there are no soloutions, so I thought I'll post to
see if anything has been discovered.

Specificaly I am trying to update a linked table connect property.

strLink = ";DATABASE=" & strBackEnd
Set dbTable = db.TableDefs(linkedTableName)
dbTable.Connect = strLink
dbTable.RefreshLink

I have tried adding db.close and get the same result.

If the code executes, and then I try to make changes in vba code I get
the above mentioned error. I also tried a variation of the code where I
use CurrentDB.TableDefs(linkedTableName). to perform all operations
directly without extra objects, but I get the same error.

Any help or ideas would be highly appreciated as I can't anything to
solve this.

Thanks!
-Elie

Aug 22 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.