Re: Multi-User Error Message

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Although this is often reported, and I've occasionally experienced it myself,
I believe it's unusual unless someone opened the database "exclusively". This
is not the "default" method of opening.

I'd be inclined to re-boot the ENTIRE network (or wait until such an
opportunity arises) before investigating further. It's quite likely that some
PC or other may be in a state which pre-disposes it to act naughtily.

OTOH (On The Other Hand) someone may be able to list the actuals which can
cause this. I have never seen a comprehensive list. For example, and
inevitably when I try two openings on the same machine, no such exclusivity is
apparent?

Chris

PS at least it tells you which machine. You haven't said whether turning that
machine off solves that instance, in which case you would verify whether the
message was correct? Is it always the same machine? Guessing is not usefull.

PPS the version of Access may or may not be relevant, and you kindly forgot to
tell us. All versions of Access are discussed here, sometimes generically and
sometimes specifically. To me there is no such problem, though I see it
reported often here and I don't know why I don't suffer it!

PPPS there may be different versions of Access incl SP levels on different
machines. But then, I'm just guessing!

"Shar" <Shar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:589D162C-36C4-46D5-89A7-595C9B575759@xxxxxxxxxxxxxxxx
I have created a simple Access database intended for multiple users.
Everybody who is intended to use the database has been able to get on to it
at the same time. However, there is a message that appears, quite often:

The database has been placed in a state by user 'Admin' on machine
'blahblahbla' that prevents it from being opened or locked.

If everybody that's in it gets out, then the message goes away and we start
all over again. Eventually the error appears again. What can I do to make
this stop?
--
Thanks, Shar


.

Relevant Pages

  • Re: moving to 2003 from 2k
    ... ensure exclusivity: ... On Error GoTo errHandle ... Dim db As Database ... Resume exitFunction ...
    (comp.databases.ms-access)
  • Re: SQL CE 3.5 and Data Loss on SD Card
    ... with a database on SD card I would be greatful. ... devices we have experienced only one corrupted SDF database. ... I attribute our success to opening a connection just before every DB access ...
    (microsoft.public.sqlserver.ce)
  • Re: 2002 database corrupt and unuseable after upgrading to Access
    ... >> This refers to an empty class module. ... >> Opening the database with the shift key down bypasses the autostart form, ... >> but then opening the VBA code produces the same sequence of errors. ...
    (microsoft.public.access.conversion)
  • Re: SQL commad each time I open MS Word
    ... Opening this document will run the following SQL command: ... information from a database -for example, if your document is a form letter ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Prevent database open if already open by a user
    ... I added 1 field to the receiving table and called it "Lock". ... this lock during the close operation, when the user exits the database. ... developing because this particular database needs to be set up for one user ... it does not prevent the DB from opening or operating. ...
    (microsoft.public.access.modulesdaovba)