Applying Filters

[Guest]

I have written a multi-user database in Access97 where up to 15/20 people can
be accessing at any one time. I seem to have a problem: Let's say that one
user has applied a filter on a field which returns about 30 records. If
another user happens to be in one of those 30 records, whether they are
viewing or updating the record, the other user seems to get a lockout message
as follows:
"Couldn't save currently locked by machine xxxx"
"Save operation failed"
"Out of memory".

Has this message got anything to do with filtering or is it just the fact
that too many people are using the database?

Any suggestions would be most welcome.
Thanks

 

[Allen Browne]

Have you split the database, so each user has a local copy of the front end?
That solves lots of issues. More info:
http://allenbrowne.com/ser-01.html

If it is already split, is there any code that is dirtying the record
unnecessarily? For example, if you assign a value to a bound control in the
Current event of the form, it is instantly dirtied as soon as you move to
any record.

It is also possible that you have an incipient corruption. Compact the
database. Make a backup copy. Then decompile by entering something like this
at the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

(Presumably you are using optimistic locking.)