Record/Page Locking

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

Hello all,

Using Access ’03 on Win XP machines…

I have a database with 1 _be.mdb and about 30 _fe.mde. Accessing the
mdb is pretty quick if you’re the first user. If you’re a subsequent
user (i.e., someone is currently in the mdb) accessing the mdb takes a
few seconds longer.

This may be a silly question: I’m wondering if there’s a way to open
the mdb without any kind of locking? I’m assuming the mde files will
access the mdb much faster.

All 30 users store data in the same table(s), but because of the fe
configuration, they can only access their records which are stored and
retrieved by a UserID.

Any thoughts?
alex
 
You can't open with out any locking. It locks records, not the entire form. I
assume you have the BE on a lan where users can access it? Remember that all
users need read/write/edit/and delete rights to the BE and the folder it
resides in. Is it possible you have a network speed issue? Is it possible you
have a server speed issue? Make sure you have loaded all service paks and
patches for your system.
 
You can't open with out any locking. It locks records, not the entire form. I
assume you have the BE on a lan where users can access it? Remember that all
users need read/write/edit/and delete rights to the BE and the folder it
resides in. Is it possible you have a network speed issue? Is it possibleyou
have a server speed issue? Make sure you have loaded all service paks and
patches for your system.
--
Milton Purdy
ACCESS
State of Arkansas










- Show quoted text -
Click to expand...

Thanks Milton.
The program only takes about two seconds to load and about four
seconds when the mdb is locked. I suppose I'm being a little too
particular.
alex
 
Back
Top