Query not Updateable-User parmission problem(?)

[barrios1]

Query not Updateable-User permission problem(?)

Hello. This is my first post so please be kind!!

I am working on a MS Access database which is accessed by 5 users in an office. Someone (not me!) recently installed MS Office(SR Professional) on to the server machine in the office but not on the others which run a previous version.

The problem I have is that some of the queries are now giving the messag 'this recordset is not updateable'. I'm pretty sure the new installation is the problem as the queries in question are based on single tables with no other complications.

Any help would save my life!!!!

 

[llkhoutx]

A "non-updatable recordset" results from a query with one or more joins and a field appearing in more than one table, such that the result doesn't know what table a particular column (field) goes with. Access is dumb sometimes.

The problem is not because of the the Office installation.