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

cannot lock database

P: n/a
Hi
i have a number of databases on a network
i have pulled all the tables from the databases into one database
on open i run an autoexec which call a macro to
1. delete existing table
2. import the table

i am now getting an error telling i cannot lock to the table beacuse it
is in use by another person
i checked the dbase is closed
i have full read write save priviages
can anyone tell me how i can resovle this problem

thanks

kevin

Jan 6 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
is the tmpfile closed

Jan 6 '06 #2

P: n/a
Check for a .ldb file in the folder containing your database. If this
file exists, delete it. Then try to delete the table again.

Jan 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.