Record/Page Locking

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
 
G

golfinray

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.
 
A

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 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 -

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top