Not updateable form even when replaced with old form

JMarie

Registered User.
Local time
Today, 08:20
Joined
Aug 15, 2015
Messages
19
Hi there.
I have never come across this and I'm hoping for some insight.
In my database I have a form that is now saying it is not updatable.

I went to a previous copy of this database and the form works fine there. I took a copy of this working form (and query behind it) and replaced the problem form. I get the same error- not updateable. Not sure why it works in one database but not the other.

-Both databases are pointing to the same sql backend.
-I ran a repair and compact before bringing in the copy of the form
- I checked the button that opens the form to confirm I didn't accidentally change code there.

What else?
 
Hi. Are you referring to the data not being updatable? If so, are you connecting to the backend server using the same credentials on both databases?
 
if you have a query with a few joins , then depending on the join , it may set the results as read only.

or the recset is set to snapshot
or the form is set to read only
 
check the Joining fields of your query.
one must have a Primary key in order for the query to be updateable.
 

Users who are viewing this thread

Back
Top Bottom