Query works in SQL Server, not in mdb back end

[RichO]

I have been creating a version of our database for laptop use which would have a standard mdb back end as opposed to the SQL server back end we have in our building.

I have it working fine except that there is one query which has 4 joins within. When I use this query with the mdb back end it is a non-updateable query (won't let me change any of the field values). In SQL server it works just fine.

I have checked all of the table properties and user permissions and everything allows writing to this table, except when it it's in this query.

If I remove the joins, I can then change the data.

Can anyone tell me what the problem might be? Thanks

 

[pbaldy]

Try

http://support.microsoft.com/default.aspx?scid=kb;en-us;328828

or

http://allenbrowne.com/ser-61.html

 

[RichO]

Thanks for the links. The problem was a missing primary key. I was not aware that the primary key did not transfer over when you use a make table query.