Single User -- can't update -- Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a single-user database that was working fine. I changed a couple of
queries & forms and now can't update either the data in the forms or queries.
I can update the underlying tables. The permissions look the same for the
database that doesn't work and an old one that doesn't.
HELP!
 
Joan said:
I have a single-user database that was working fine. I changed a
couple of queries & forms and now can't update either the data in the
forms or queries. I can update the underlying tables. The
permissions look the same for the database that doesn't work and an
old one that doesn't.
Click to expand...

The obvious question is 'what did you change'? This does not sound like a
security/permissions issue. You may have made a change in the query that
resulted in it no longer being updatable. Go into Help and type updatable
query. The topic will explain why/when a query may be updatable.
 
Back
Top