Strange issue after loading latest data

J

Jack

Hi,
I have an access application that works well in testing environment. I
created a different folder for my own testing and dowloaded the latest
production data of a previous release to test my new release.

However the main form when I am trying to edit is not being uptateable. The
code is exactly the same as the first test environment with few test data. I
am not sure why this would happen as I have taken the copy of test
application and got a copy of current production database to test for
functionality.

I appreciate any help or direction to resolve this issue. Thanks.
 
A

Allen Browne

If the form is based on a query, see if the primary key field is no longer
marked as PK in the table.

Other suggestions for a query:
http://allenbrowne.com/ser-61.html

If the form is based directly on a table, see if you have set these
properties of the form:
- Recordset Type Dynaset
- Allow Edits Yes
or these for the text boxes:
- Locked No
- Enabled Yes
 

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