One form, multiple users

  • Thread starter Thread starter C#''er
  • Start date Start date
C

C#''er

Ok. Ive been searching the group for answers to this questions and have yet
find a sutible answer....i will attempt to explain as simply as possible. I
am creating a BE Database, there will be multiple users linked to the BEDB
via the front end. The linking is fine, however, would like to have the users
use a form to input data. I have created this form once. i would like to know
if there is a way I can have each user use the form without having to create
it from scratch. During the set-up
 
Thank you for your reply Rog, but this option does not work. I get the error
message "The database engine could not lock the table "Table Name' because it
is already in use by another person". Anyother suggestions.
 
Is this Front End database used by multiple people on the network? Because
if it's not, something else is going on. In general, my suggestion should
work. If it's on the network, copy it to your hard drive, make the form
changes, then copy it back to the network. Have each user copy it down to
their hard drives. The links will remain to the network Back End.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
I got the same error when I tried to make a report used by multiple people.
I split the database, etc. but couldn't find a solution to the "could not
lock the table" conundrum.
I wish you the very best of luck.
 
There are a number of things that can cause this problem
1. All users need to have read, write, and delete permissions on the folder
where the backend mdb resides. Mdb files have an associated ldb file. It is
the locking file that controls multi user access and locking. It is created
when the first user opens a front end linked to it. As each user opens or
closes their connection, it is modified. When the last remaining user closes
the the connection, the ldb is destroyed. If the users don't have sufficient
permissions, it will not work correctly.

2. Make sure no user is opening the database in exclusive mode. That will
cause the backend to also open in exclusive mode and no other user will be
allowed in. But, if it is already open and a user tries to open in exclusive
mode, they will get an error it will not open.

3. Be sure you have the locking options set correctly. Tools, Options,
Advanced Tab
Default open mode should be Shared
Default record locking should be no locks
Open databases using record-level locking should be checked.
 
Back
Top