This recordset is not updateable

[Joshua Beel]

I have a frontend database linked to a backend database on a central server.
I have a form that has been working correctly for several months now and
suddenly i cannot change anything and it says in the status bar at the lower
left side of access "this recordset is not updateable". I have tried
compacting and repairing the backend database and still no luck. The Front
end Database is on 5 computers in the office and they all have this same
issue. Can this be fixed?

 

[Steve Schapel]

Joshua,

Are you able to tell us please what is the Record Source of this
troublesome form? If it's a query, could you copy/paste the SQL view of
the query into your post here? Thanks.

 

[Joshua Beel]

The recordset is a set of 4 linked tables. Thanks for the timely response!

 

[Steve Schapel]

Joshua,

I assume you mean Record Source? And I assume by "4 linked tables" you
mean a query? Well, I think we still don't have enough information to
go on at this stage. Can you please have a look at the Record Source
property of the form. If it shows a SQL statement in there, please
copy/paste that into your reply. If it says the name of a query, please
open that query in design view, select SQL from the View menu, and paste
that into your reply. Thanks.