Access security

[xenou]

I am sure at some point in the near future I will think this is obvious ...

I'm planning on using a workgroup file to set up basic user groups and privileges, to prevent some of my users from making changes unwittingly or messing around in tables.

1) I'll have a form to use for adding records to a table;
2) I don't want my users to have direct access to the table;
3) I do want my users to be able to update the table with changes and new records;

My question: if I give my user Write access to the "form" (and thereby to the form's record source), will I still be able to deny Write access to the "table" (even though they can update the table using the form)?

Its funny that this strikes me as a contradiction - but then, I remember when x = x + 1 was a strange contradiction to me too...

Regards,
AB

(My main goal will be to force users to use a form because in fact, I want to have two tables updated - one which is a primary record of an asset, and the other which is the location of the asset, with dates - so that if it moves, I can still locate it in space/time for previous months. If users could update the tables directly, they may ignore this second table).

 

[Dartagnan]

Sorry. I see the drop down now.

Not quite what I was looking for. I don't want my users to have access to any tables/forms/queries.

Right now I have the Database Windown hidden and I reassigned the F11 function with a macro. Then I hide the Menu Bar so a person can't change settings. However, I feel this is a band aid. Should I use User and Group permissions too?

 

[skaas]

If you are confident enough with coding you can set up user groups internally also, allowing you to set permissions internal to the access program as well as externally..

Try the Developers Centre it has some handy info on User Groups and permissions - It's just a case of sifting through the archives.

This link below should put you on the right track

http://msdn.microsoft.com/en-us/library/bb177894.aspx

I hope this helps

 

[SydneyGeek]

Sorry. I see the drop down now.

Not quite what I was looking for. I don't want my users to have access to any tables/forms/queries.

Right now I have the Database Windown hidden and I reassigned the F11 function with a macro. Then I hide the Menu Bar so a person can't change settings. However, I feel this is a band aid. Should I use User and Group permissions too?

It's not quite a band aid. It's a layer that you need, but you need to do several things to secure a database. If you really want to understand database security, get Real World Microsoft Access Database Protection and Security by Garry Robinson. He knows his stuff. but properly securing a DB isn't a trivial exercise. He mentions that just about any database can be secured in about a week or less.

Denis