Permissioning Tables

[ChloeRadshaw]

So I come from a Sybase background and found out the hard way that the database needs to be read / write in order for someone to make an update to the database using VBA.

I am actually quite surprised by this.

Does anyone know if:
1) This is the case
2) How you can permission people on a table by table basis?

[OBP]

Cloe, are you talking about Access here, the only time that Access needs any kind of permissions is when User Level Security has been invoked.
If this is not necessary then you could import all of the database objects to an Unsecured blank database.
If the Security is required then you use main menu>Tools>Security>User & Group Permissions
You can highlight all of the tables and give the same permission to all of them or one by one.

It is usual to not give Individuals permissions as that is a waste of your time, you normally place them a "Group" and give the Group the permissions. So you might have a "Viewing" group who can only look at data, a dataentry group who can input, edit and delete data and an Admin or Security group who can do whatever is necessary to maintain & develop the database.

[ChloeRadshaw]

Cloe, are you talking about Access here, the only time that Access needs any kind of permissions is when User Level Security has been invoked.
If this is not necessary then you could import all of the database objects to an Unsecured blank database.
If the Security is required then you use main menu>Tools>Security>User & Group Permissions
You can highlight all of the tables and give the same permission to all of them or one by one.

It is usual to not give Individuals permissions as that is a waste of your time, you normally place them a "Group" and give the Group the permissions. So you might have a "Viewing" group who can only look at data, a dataentry group who can input, edit and delete data and an Admin or Security group who can do whatever is necessary to maintain & develop the database.


Thank you very much.

Does the database need to be writeable for updates to take place?

[OBP]

Yes, in it's normal condition it is writable, it should not be used in "Read Only" format as the security can take care of that.
Is it already secured?
Do you have Administrator rights?