.ldb questions

[Scott Bray]

I'm running into some problems with a large shared
database. The database is pretty slow if you are the
only one in it, but say you open it on one computer and
run something then go to a different computer and run
that same thing it's at least twice as fast. It not an
issue with the machines because you can replicate it
either way. Seems to me that ldb file has something to
do with it, is there anyway that when you close a
database you can keep that ldb file from being deleted.
Can anyone shed some light on this subject or tell me
more about what the ldb file does, I looked in the
knowledge base and it didn't give me as much info as I
expected. Thanks.

 

[Tony Toews]

I'm running into some problems with a large shared
database. The database is pretty slow if you are the
only one in it, but say you open it on one computer and
run something then go to a different computer and run
that same thing it's at least twice as fast. It not an
issue with the machines because you can replicate it
either way. Seems to me that ldb file has something to
do with it, is there anyway that when you close a
database you can keep that ldb file from being deleted.
Can anyone shed some light on this subject or tell me
more about what the ldb file does, I looked in the
knowledge base and it didn't give me as much info as I
expected.

Interesting. Usually the performance problem is that one user is fast
and two are slow as molasses in Canada in January. See the Access
Performance FAQ at my website for more info.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm