Data-Entry option error

[stranger]

I have an Access database on a shared drive. It is used by 8-10 people
at any given time. I have a form set up to be opened in either "add" or
"edit" mode. The problem I am having is the "data-entry" option on the
form is changing to "YES" by itself. This doesn't allow users to view
the records in the table, they can only add. I change the setting and
it will work for a while but then change back again.

Does this have something to do with multiple users trying to access the
form at the same time. Any help with this would be much appreciated.
-stranger

[Allen Browne]

Did you split the database, so that each user has their own local copy of
the front end?

If that's a new idea to you, see:
Split your MDB file into data and application
at:
http://members.iinet.net.au/~allenbrowne/ser-01.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"stranger" <th***@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I have an Access database on a shared drive. It is used by 8-10 people
at any given time. I have a form set up to be opened in either "add" or
"edit" mode. The problem I am having is the "data-entry" option on the
form is changing to "YES" by itself. This doesn't allow users to view
the records in the table, they can only add. I change the setting and
it will work for a while but then change back again.

Does this have something to do with multiple users trying to access the
form at the same time. Any help with this would be much appreciated.
-stranger