The Recordset is not updatable

[bullet_proof302]

Hello,

I created a database and splitted it.
i put the backend in a server and sent the front end to the users.


However, the user can't update his records and the form is showing that the recordset is not updatable in the status bar.!!

in addition to that, I have a module that connects to the backend dynamically to search for a record. the code is running in my pc perfectly but not running in any of the users showing
run-time error '3051'
stating that the backend database is open exclusively or in read-only mode eventhough i gave the users full permission to the backend.

please help

[NTC]

your statement of "I gave users full permission.."...are you using the User Level Security of the Access security feature pre-Access2007?

I would check the security/permissions of the back end folder relative to the front ends...

If you have Access2007 - I would check that your TrustCenter includes the relevant backend and frontend locations.

[bullet_proof302]

the backend is on a file and print server and this is the one which i gave full permission on.

I'm not using the access 2007 level of security, and the default settings of the user's microsof access is that all macros are disabled and the trust center is active. however, i tried to disable them but the same problem still exist.