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

ADODB connection can't open. Database locked.

P: n/a
Hi, I used DAO and it works fine. But when I try to use ADO, it says
the database is locked by the user. How can I get around this? Which
property should I set?
Thanks.
ming

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
swingingming wrote in message
<11**********************@g14g2000cwa.googlegroups .com> :
Hi, I used DAO and it works fine. But when I try to use ADO, it says
the database is locked by the user. How can I get around this? Which
property should I set?
Thanks.
ming


Since there's no information about how you're performing this, which
line gives
an error... it'll be guessing... and here's one guess

- if you're using the current database, don't open a connection on it,
but use
currentproject.connection as your connection
- if you're invoking this from a bound form (I wouldn't know why one
should
that), but then issue some kind of save comman first, for instance

if me.dirty then me.dirty = false

- are you opening a connection against a separate db (in stead of
using
currentproject.connection to get at linked tables), you might want
to check out
your connection string here

http://www.carlprothman.net/Default....orMicrosoftJet

watch for breaks in the link

--
Roy-Vidar

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.