Not updateable form even when replaced with old form (1 Viewer)

JMarie

Registered User.
Local time
Today, 02:42
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?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:42
Joined
Oct 29, 2018
Messages
21,358
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?
 

Ranman256

Well-known member
Local time
Today, 02:42
Joined
Apr 9, 2015
Messages
4,339
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:42
Joined
May 7, 2009
Messages
19,169
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

Top Bottom