I've read around here and there about record locking and have come up
with kind of an incomplete mixed bag of results. A particular app I'm
working on is more prone to concurrent record editing contention than
most I've done. Here are some bits of info an experience that I'd be

We have an access application which is split into a front & back end file &
resides on a single PC.  4 other PCs access the app through a peer to peer
connection.  We have created the app so that Access is automatically set to
compact & repair whenever the app is closed on any of ...

Using A97 on a LAN.
Our backups usually occur at night when there is no activity with the
data mdb. Occasionally we may have a user leave their front end mde open
to the back end mdb, but no issues.

I am using A2K and the 'ShowUserRosterMultipleUsers' procedure from MSKB to
establish who is logged in and using the backend data file on  network.
It works fine in my office LAN using Windows XP Pro, but fails when run on a
client network over TS using Windows 2003 Server (and A2K) ...

I've created a secure db in access 2003.
When I join the the workgroup security.mdw, the security I've put in
place works all right. when open it asks for password, doesn't allow
the user level to modify, etc.

Hello, Dzień dobry!  (Good Morning)
Having to update a db frequently can be frustrating when i have to wait for
people to get out of it.  So i have a secured db, can i do something so I can
update whenever i want?  i have heard of something, i think it can be done,

I have an Access Database on our network, and I want to be able to see who is
currently using the Access File. The users login to the network, but do not
login to the Access Database. We use Windows XP Professional and Access 2003.
Is there a possibility to see which users ...

I have a client who is a manufacturer and an Access application is used down
on the shop floor where they have PC's in each production area.  Currently
when a transaction is entered the worker just selects their name from a drop
down list but the problem with this is that they ...

I have a customer who recently added a wireless laptop user to his group of
users that are using an Access 2000 database application I developed.  All
has been working great until the wireless user has come on-board.  However,
now the database corrupts.  I'm thinking that ...

I have developed a db that is currently split into a fe and be.  My
co-worker and I share the db in our office over a LAN (fe installed on our
desktops, be on server).  However, we would like to share the db with other
offices throughout the state (we work for the state gov.)

Hi, some of my customers have the problem where the 3rd
or 4th users take much, much, much longer to start our application. There is
a front-end mde file and a back-end data file (both in Access '97). The
front-end mde file is started

I have a multiuser database that runs some code to print a report to a pdf
file using Acrobat Distiller. Distiller is configured to NOT prompt for file
name & always overwrite any existing file. This DB has just been converted
from 97 to 2003. This process worked great in 97, I ...

We have an Access database Sch.mdb in the shared driver S. I want to
make a change to the form and the code. However one user is always
login to that database and I am unable to make such a change.  The
utility LdbView found that a computer named 1X23Y45 is login to the

Is there a way in microsoft Access VBA, that you can restrict a user of
starting my application only once. Basically when he tries to run it again
while there is already another instance of the app running a warning pops up
saying "Sorry only one instance of the application is ...

This is a home networked computer - all other machines on this network
are fine.  The slowness is in booting up through the login procedure (8
minutes after the wallpaper color changes until I can begin to open a
window).  Then it may take from 20 seconds to 1 minute for a new ...