Access 97

[Ronster]

Anyone ever encountered this problem before?

A Microsoft Access 97 database sits on a server. A team of
30 use it, they all access it at the same time. The .ldb
file obviously prevents any mess ups.

However, one user gets this message every time she opens
the database and tries to save.

Problem follows her around.

Can't find a solution, though I have tried - anyone seen
it before?



"Couldn't save. System is locked by User "Admin" on
machine "xyz" "The Save
Operation failed" "Out of memory"

 

[Ronda]

Subject detail...

 

[Douglas J. Steele]

Do all of the users have Change (RWXD) on the folder where the MDB exists?

Are all of your users using the same MDB, by the way? If so, you really
should split it into a front-end (containing the queries, forms, reports,
macros and modules), linked to back-end (containing the tables). Only the
back-end should be on the server: each user should have their own copy of
the front-end, preferably on their hard drive.

 

[Steve]

Did you ever get a reply to your question below? I get
that message occasionally also. I believe it's caused by
record locks, or a range of records being locked when one
user is editing a record. But I'm not positive.

 

[monica]

Did you ever get a reply to your question below? I get
that message occasionally also. I believe it's caused by
record locks, or a range of records being locked when one
user is editing a record. But I'm not positive.