Access 2007 Security - ! !

[Ofelia]

Hello to all!

I hope everyone is going great!

Please don't tell me that Access 2007 does not have security levels. How am
I supposed to secure the tablesA? I have a simple database. I need for the
other users to view the data only. I do not want for anyone else to be able
to edit the database. However, I would like for the user to be able to sort
and filter whatever. As long as they cannot edit we are ok. Please advice.
Thank you!

 

[Douglas J. Steele]

Please don't tell me that Access 2007 does not have security levels.

Sorry, but it doesn't.

How am I supposed to secure the tables?

See whether
http://www.microsoft.com/technet/security/guidance/clientsecurity/2007office/default.mspx
helps.

 

[Minton M]

Hello to all!

I hope everyone is going great!

Please don't tell me that Access 2007 does not have security levels. How am
I supposed to secure the tablesA? I have a simple database. I need for the
other users to view the data only. I do not want for anyone else to be able
to edit the database. However, I would like for the user to be able to sort
and filter whatever. As long as they cannot edit we are ok. Please advice.
Thank you!

Doug's right. But SQL Server Express is available for free from MS
and:

1) has a decent security model
2) integrates with Access easily
3) actually works.

Unfortunately this is the only way because any user can make links to
your backend tables in Access and f--- around with them.

-- James

 

[Tom van Stiphout]

It all depends on how much security you need.
Personally I write an AutoExec macro in the back-end database with
Msgbox "You're not supposed to be here!" and DoCmd.Quit.

In the front-end, we can hide the database window, and we can provide
security based on Active Directory groups.

For situations where we are dealing with good-willing employees the
above is probably enough. If you want real security, Access is not
your platform. Never has been.

-Tom.