Security-mdw-multiple mdb's open at once

BatesAccess

New member
Local time
Today, 10:44
Joined
Apr 14, 2008
Messages
4
(Thanks in advance for bearing with this narrative down to where I finally ask my question...)

Background: Current situation
  1. On our network, each user has Access (2003) on the local machine, with the default system.mdw residing there as well.
  2. Some users (not many) create their own databases they keep on their local drive; some users create databases they store on a shared folder on the server.
  3. Whenever they open their own databases, the default system.mdw is at work (no workgroup security in place).
  4. We also have several multi-user databases on the server. They open in shared mode and record-level locking is in force.

What I'm planning:
I need to convert to user-level security for these databases that have to be accessible to multiple people at once. I'll set up a new workgroup file, neutralize the "admin" and "user" users, provide users with a shortcut for opening the database (uses the local drive exe, the network path to the mdb, and the network path to the new mdw). (Am also splitting the database).


Here's my anticipated situation:

  1. User A opens one of his own databases (which uses the default system.mdw file).
  2. User A then also opens the network-secure database (using the shortcut which uses a different mdw).
  3. User A now has 2 mdb files open, and each calls a different mdw file.

My question is:
Will they be able to do that? Or will the two mdw files collide?

I ask because Jack MacDonald's 2004 article says every Jet session uses exactly one workgroup file....and "once you start Access, your identity is established in the system until you quit from Access."
 

Users who are viewing this thread

Back
Top Bottom