Access.Lockfile.9, User Assigned Exclusive Admin Status in Concurrent DB

Access.Lockfile.9, User Assigned Exclusive Admin Status in Concurrent DB

Post by me » Fri, 10 Feb 2006 06:56:06


I created a sophomoric DB for some coworkers to log errors. When one
user locks their PC with Ctrl + Alt + Delete to go to lunch or a
meeting, the other users are unable to save changes or enter new errors
because the user with the DB open and the Windows OS locked defaults
into Admin status (or somehow is granted Admin status).

Is there a setting or option I am forgetting so that this issue does
not reappear?

[Hint: Temp Access.Lockfile.9 files are created.]

Note: The DB is split into a back-end and two front-ends.

Thanks for your help in advance. Sorry if this question is not
appropriate for this thread or I am just an idiot.
 
 
 

Access.Lockfile.9, User Assigned Exclusive Admin Status in Concurrent DB

Post by Ed Procha » Fri, 10 Feb 2006 07:12:40


I have no solution other than to suggest you get a real multiuser DB,
which ACCESS obviously isn't.

 
 
 

Access.Lockfile.9, User Assigned Exclusive Admin Status in Concurrent DB

Post by Christophe » Fri, 10 Feb 2006 08:04:59

> I created a sophomoric DB for some coworkers to log errors. When one

Hmm. Picture a Dilbert cartoon where the bearded suspendered guy says
"Here's a nickel; get yourself a real database..."
--
let name="cbbrowne" and tld="ntlug.org" in String.concat "@" [name;tld];;
http://www.yqcomputer.com/
"Let me blow that up a bit more for you."
-- Colin Powell, Discussing a picture of the intelligence compound in
Iraq
 
 
 

Access.Lockfile.9, User Assigned Exclusive Admin Status in Concurrent DB

Post by Novs » Sat, 11 Feb 2006 06:03:35

I'm sure the boys at Microsoft designed a way to eliminate this
problem, letting Access fully support a multi-user environ without
pop-up bug delivery-o-grams.