Recordset is not updateable

mamaw

Registered User.
Local time
Today, 16:30
Joined
Oct 16, 2002
Messages
24
I have a database that is split into front and back ends. I have 35-50 users with read/file scan rights only set by our MIS Network Administrator. My department has read/write rights to the database. I am the only person that uses the database though. My problem is that when certain people (and maybe any or all of the people) are in the database, I am not able to update any records. I get "This recordset is not updateable." I have checked under Tools-Options-Advanced and the Open Mode is Shared, the Record Locking is NO Locks. I have checked my front end and others' front ends in this area. I have also checked the back end. There is no security set with the database. I'm at a loss. Please HELP.
 
Then if I understand correctly, the only option I have is to give everyone read/write rights through the intranet, and to set up Access security. Is this correct?
 
Thanks, Pat.

I think we have the problem resolved.
 

Users who are viewing this thread

Back
Top Bottom