search error

[scott]

can someone tell me what's going on. when seaching a memo
field in a database we search by certain keywords. when
you start searching an error comes up saying that the jet
database has stopped because you and another user are
attempting to change the same record. no one else has
access to the database on the network and when you copy
the database to the pc you get the same error.

thanks

 

[Bryan]

Scott,

In todays networking environments, the Jet enigine
(Access *.mdb files) is not the greatest technology for
multiuser databases. Sometimes, the locking database
([database file name].ldb) stays open in memory, after
all users have closed out of the database. If this is the
case, Access still thinks that there are other users
connected to this database file, even though none are.

If this file persists (in the same location as your
*.mdb) even after the application has been closed, you
should do the following:

1. Backup up your database file (make a copy of it
somewhere else with a modified name).
2. With the original *.mdb file closed, delete the *.ldb
file.
3. Open the *.mdb file and see if this fixes the problem.

Bryan