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

Exclusive use warning message

P: n/a
When I open a MSAccess 2003 database that is already open by another
person I get this warning message about the database already open by
someone else ...

I like the message but it requires 32 exactly clicks to get rid of it.
Any suggestions

Jun 5 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Jun 5, 3:28 pm, Tom Louchbaum <t...@uwm.eduwrote:
When I open a MSAccess 2003 database that is already open by another
person I get this warning message about the database already open by
someone else ...

I like the message but it requires 32 exactly clicks to get rid of it.
Any suggestions
Unplug it, put it back in the box and buy a notepad.

You should only get that message if th eother person who has it open
is EDITING something (i.e. a form or report). It should take 1
exactly clicks to get rid of it. If it takes that many clicks, then
it's probably linking to another database and it may be THAT database
which is locked (opened in Exclusive mode) for editing.

Are you the person who wrote or edits the code in this database?

Jun 5 '07 #2

P: n/a
On Jun 5, 4:28 pm, Tom Louchbaum <t...@uwm.eduwrote:
When I open a MSAccess 2003 database that is already open by another
person I get this warning message about the database already open by
someone else ...

I like the message but it requires 32 exactly clicks to get rid of it.
Any suggestions
Try open shared. ms-access -Tools -Options -Advanced -( there
is a choice to open exclusive/shared)

Or wake up earlier to be the first opening it! (just kidding) ;)

Jun 5 '07 #3

P: n/a
ManningFan <ma********@gmail.comwrote in
news:11**********************@n4g2000hsb.googlegro ups.com:
On Jun 5, 3:28 pm, Tom Louchbaum <t...@uwm.eduwrote:
> When I open a MSAccess 2003 database that is already open
by another
person I get this warning message about the database already
open by someone else ...

I like the message but it requires 32 exactly clicks to get
rid of it. Any suggestions

Unplug it, put it back in the box and buy a notepad.

You should only get that message if th eother person who has
it open is EDITING something (i.e. a form or report). It
should take 1 exactly clicks to get rid of it. If it takes
that many clicks, then it's probably linking to another
database and it may be THAT database which is locked (opened
in Exclusive mode) for editing.

Are you the person who wrote or edits the code in this
database?
He's got the same problem with his .mdb as I have with one I
created. One user will lock out everybody else. If he tries to
to open the .mdb, and anybody else has it open he gets about 20
of those popups. The user in question and all others have only
Access 2003 runtime, launched by a script.. The .mdb (front end)
is on a shared directory, the back end is in SQL-Server 2005.

Other users seem to be able to launch the app simultaneously.

I wrote the code for this baby, and before our IT dept hijacked
it, it worked perfectly well from a share I created from my
local HDD.. .
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jun 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.