I'm seeking a little advice about how this should be handled in a multiuser
access application. We have a split access 2003 database with each client
having their own front end. In our current scheme of things it's likely that
multiple clients would be editing the same record ...

on machine 'XXXX' that prevents it from being opened or locked." in a VBA
application.  I have had multiple users (everyone runs Windows XP) in MN
connecting to an access database on the MN file server (running Windows
Server 2003) for several years without and database locking ...

My mdb fe links to multiple back end mdb files - the recommended code from
The Access Web works but only lets me select one location and then tells me
a particular table (from a different back end) doesnt exist.  How can I
select multiple back ends one after the other (if that ...

I'm starting this thread to pull together related questions and to
check my understanding. Please debate apparent misconceptions.
Do you agree that these are best practices?
1.  Use JET OLE DB when connecting to BackEnd (BE) MDB file. Reason -

hi all, thanks everyone for the help in the past, i really appreciate that.
Now i have a new problem and help would be really appreciated.
I have a small network based on 4 computers. I have the main Database on the
server. I have all 4 computers connected to the database and they ...

Gentlemen - I have a problem with one of our databases.  I would like to
have one person able to modify the database and every body else should only
have read access to the database.  The problem is when the person who has
full access is in the database nobody is able to view the ...

I need user security without installing then internal user_level security. In
the book: Access Cookbook by K Getz et al. they suggest to creat your own pub
function. Can anybody write a simple code for changing the CurrentUser with
the NetworkUserName so I can use it in all forms ...

I have a multi user database that goes exponetially when it is use. It is a
split database. Each user has their own deont end. However you can literally
'watch' it grow when I have twelve users in it at the same time

I need to create a multi user application. I want to split the MDB into
two. At the user's C Drive will be the front end. On the server will be
the back end database.
I want to do this application in ADO.

I create a new MDW file, then logged in and created a new database and
added a super user. Then I removed all the permissions from the admin
and user. Know when I go back to the serurity I can't add any user and
the group tab is missing. How can I get this back.

I want to have my database shared in a network (maximum number of users are 3)
. But i dant know how to build it. Considering the references I have read and
about the limited users only, then I want to have it not splitted i guess.
Thank you in advance for the helps.

I have an Access ADP deployed on Citrix to a number of servers.  When the app
is opened by the first user everything is OK.  Subsequent users receive a
message stating tat the file will be opened read only.  The message appears
whether the users are on the same physical server or ...

i have four computers connected to a D-Link 4-port router that also acts as a
DCHP server. the problem is that the three computers are doing 100 mbps while
the fourth computer can only do 10 mbps. If i force the forth computer to do
100 mbps, it can't communicate with the routher ...

We have a database on a network drive used by 6 people.  At the moment,
when anyone tries to open it, they receive the error message:
"The database has been placed in a state by 'Admin' on machine
'<computername>' that prevents it from being opened or locked."

In an Access multi user application I am able to read and update
backend db tables fine using RWOP queries.
One table (TABLE A) in the backend db uses the Combo Box, RowSourceType
= Table/Query settings or some fields so they display drop downs on