Access will not allow a user to save the data

M

myztiques

There is a user at a differetn location that can enter the information on the
form but when she closes the form the data is not saved or recorded.
However, the other people in the office can enter and record the data. What
could be the problem and the possible solution?
 
A

Allen Browne

Hmm: could be lots of things.

Might be this issue:
http://allenbrowne.com/bug-01.html

Could be her Windows permissions are inadequate. Logging on as a local
computer administrator might solve it.

If the database is secured (MDW), it could be an Access permissions issue.

If it is a linked database, she may have used the wrong share when attaching
to it, or she may not have adequate network permissions.

If she edits the database objects herself, she could have set the form's
properties wrongly - particularly Record Source, Recordset Type, AllowEdits.

It could also be a macro or code that is silently cancelling an event (such
as Form_BeforeUpdate) or undoing the entry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top