How can I create 3 levels of permission for 3 people in my
office to the MS Access 02 database.
The owner needs to maintain a private table too.
The admin is the next.

Since using XP our app (Over network - database on server, FE on clent)
The BE gets corrupt with loss of relationships & a wierd record in one of
the tables.
I use a rebuild (Data moved to balank DB) is only way to fix.

I have a split database running under MS Windows 2000
5.00.2195 on a network server.  It is very, very slow and
there are only 2 concurrent users.  Any suggestions?
If the problem is the network, how can I get a benchmark

I could last week, but today I'm getting the message
Cannot Create MDE file.  Any suggestions?

i am having trouble with my secured database.  i have
read only users, admins, and full data users.  i would
like to have the full data users and admins to be able to
edit records while read onlys are in the file.  Right

Users will use both AXP and A2k3:
We use one workgroup file on a mapped drive for our local .mde files.
We use a command switch in a desktop shortcut to point to the
workgroup to avoid Access reverting to the default system.mdw.  Admins

Does anyone know of any problems with multiusers in a mixed Win 2000 Win XP
environment using Access 2000 FE/BE with BE stored on a Windows 2000 Server.
I had problems with win98 and win2000 until everyone was upgraded to
win2000.

I have a Access 2000 multi-user database with one backend and multiple
frontends.  One user sporadically receives this message:  "The database has
been placed in a state by user 'Admin' on machine 'XXXXX' that prevents it
from being opened or locked."

  Does Access support concurrency control?  I mean Does it makes sure the
data keep serializable when multiple user is updating the database?  Or Does
its support multiple user?
   Thank you very much.

I created a secured Access 2000 app (MDE). The peer-2-peer network has 2 PCs
using Win98, 1 laptop using WinXP and the server using WinXP again. No
domain server is used. Just a simple network setup. I have installed the app
on each PC on the network and the MDB on the server. On ...

I have an Access 2002 database that has recently been
mounted in a shared folder on Small Business Server 2003.
It is set to auto-compact when the file is closed
(basically to stop the users having (ie failing) to

even if my application (ACCESS97) is on a sharde drive and in share mode ( vérified in options /advanced tab) but when the other user want to open it from another PC on the LAN (NT 4 servers and W98 PC for users), he get the message : file can not be open scince already opened ...

I hope this is the correct forum for this.
I have a database and will be placing a copy of the database on a
notebook computer for our salesman to use. The salesman will be making
additions to the tables as well as updating existing records. In

I have built a few databases for managing company
information.  Everybody in the company has Office 2000
installed, everybody is on the same LAN, the databases are
in network folders, and the databases will typically be

I have a split database where the users keep the backend
in a shared folder on the network and then they copy the
frontend to their local computer.  It has code in it to
find the backend upon first opening the database.  This