Locked? What did I do???

[jwoods7]

I have a multi-user database that all remote computers access linked tables on a server via a LAN. Occasionally I get this error when trying to open the front-end database:

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


What did I do? I haven't set any passwords under 'Database Utilities' and I'm using Access 2000

 

[psemianonymous]

Similar threads:

http://groups.google.com/groups?hl=...a+state+"&meta=group=comp.databases.ms-access

There are basically two possibilities:
1. You're manually doing a "db.Close" to all your DAO.Database objects. When none remain open, the database "closes" itself in the manner you have described.
2. You're running a multi-user front-end. With Access2000, multi-user front-ends are discouraged. And I quote: "and mutliuser frontends are
pretty much dead now for all time" (thread

http://groups.google.com/groups?hl=...te+%22&meta=group%3Dcomp.databases.ms-access)

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[jwoods7]

By "multi-user" front end I am not using the same program for all computers. The server has a database with the "DATA" and each computer has it's own file "accounting.mdb" that links to that data. So multiple copies of "accounting.mdb" access the info, not just one.

I don't know what you mean by db.close
I do have some recordsets open and close them, for example like this:

set invrec = currentdb.openrecordset("SELECT * FROM [Invoices]",dBOpenSnapshot)
invrec.edit
invrec![Invoice Number] = "whatever I want to go here"
invrec.update
invrec.close

Is that kind of what you were talking about?

 

[psemianonymous]

No, it looks like you're doing it right. What I was referring to is actually making a Database object and then running the ".Close" method on it, i.e.

Dim db as Database
Dim rs as Recordset

Set db = currentdb
Set rs = db.openrecordset("some SQL&quot

rs.close
db.close


I think there's a MS knowledgebase article on the error message too--check it out. The thread link was to give you a general feel of how others are receiving the same error as you--check them out too. At least you can scratch out the "multi-user front-end" problem.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm