Access 2003, cascading updates fail for users

C

CWDev

In Access 2003, why do cascading updates work for the developer and not for
users? This behavior (likely) began upon installation of Office 2003, though
the DB is in Office 2000 format.

The implementation is client server.
Users have full rights to the folder containing the backend.
Linked backend tables show relationships with referential integrity checked
but grayed out and cascading options are not checked.
In the backend DB, cascading is selected.
Access security is not used.

Any thoughts?
 
M

[MVP] S.Clark

Did you check that the Cascade updates checkbox is still checked for that
relationship?
Sorry to ask the obvious, but it is the first place to start.

Also, there is no "Client Server" setup with Access Jet tables. It's just
split databases. Client Server would be using SQL Server, MSDE, or other
such server.
 
Top