User Permissions Problem?

[spaulding]

I have a split Access database running over an NT network. I built a form to enter and update data and secured (a little) the database with a password. This database is designed to be used by a group of ~5 people, all of whom need to be able to update. The folder where the DB backend is stored is Full Control (sharing and security) to all the members of this group. My problem is-I'm the only person who can update! If one of the other members of the group is logged in to the network, they can view the data, but not update. There is a message on the status bar saying "Recordset not updateable". If I login, everything works fine, no other changes other than me logging in. I think this is a permission problem, but I'm not sure where I screwed this up. Help Please!

 

[THoey]

Can you log in from their machines? Is this one of those times when the SYSTEM.MDW needs to be copied to their machines? Haven't done security yet, so this is REALLY just a guess... Terry M. Hoey

 

[spaulding]

Sure have. One of my users is not hesitant to call when there's a problem. I go to her computer, check the DB ("Recordset not Updateable" shows while form is loading). Log her off, log me in, start the DB-everything works fine. I've tried this on other computers, same problem. As long as I use the NT account I first created the DB with, updates work great. With any other account, Access won't let me update. Appreciate any help you can give.

 

[rann]

Hi,
IF you have Security (system.mdw)at the BackEnd DB.
Make sure you have given permissions to
Update,Delete to all the users.
You must have created all the databases and
you must have been the Admin, that was the
reason you could log in.

Look at Access Permissions,NT Network Permissions Too.
Since you say they have Full permissions to the Folder.

Hope this Helps,

Rann