Error message when another user tries to open data

[wwalters]

I've run into a wall when it comes to allowing other
users to open a data base for just read only. When I
have it open and another user tries to open it an error
message comes up reading "can not lock file". If I close
it down, they can open it up as a read only file...which
is the only access I want them to have.

How do I fix it so that they can open it up, when I have
it open?

 

[Michael Viescas]

It sounds like you are setting the file properties of the
database itself to Read-only. This isn't going to work if
you want multiple people to have access to the database at
the same time (it has to be writable to be shared).

Instead, try using Access security to set up accounts for
your users and give read-only permissions on the tables to
the users that you want to have read-only access. You can
find more information about working with Access security
on Microsoft's support website.

HTH

-Mike