Access 2007 - Security

J

Joe

Why, for God sake, does Microsoft eliminate the user level security in an
Access Database 2007.

How can I recommend this new version to my clients, who uses and needs this
kind of security?

Joe, SP - Brazil
 
6

'69 Camaro

Hi, Joe or Bob.
Why, for God sake, does Microsoft eliminate the user level security in an
Access Database 2007.
Click to expand...

User-Level Security is not supported for ACCDB format files, but it's
supported for MDB format files in Access 2007. Keep the database
applications from earlier versions in MDB format, and you can keep the
User-Level Security.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
J

Joe

Thanks for your answer.

Joe


'69 Camaro said:
Hi, Joe or Bob.


User-Level Security is not supported for ACCDB format files, but it's
supported for MDB format files in Access 2007. Keep the database
applications from earlier versions in MDB format, and you can keep the
User-Level Security.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
Click to expand...
 
G

Guest

Did you solve the problem?
I have the same problem. I'd like to discuss with you.
If you prefer we can speak in Portuguese...

Márcio Alcântara
BA - Brazil


"Joe" escreveu:
 
G

Guest

I just ran across this thread while looking into the same issue. My concern
is the question of just how long the mdb file format will be supported. I'm
a newbie so please bare with me. I currently have a split db and realize I
can upsize to SQL Server for the backend and, in thus doing, gain superior
security of the actual data. What about the UI objects, though? What if I
want to prevent user's/groups from even opening certain forms or reports?
One of the great things about pre-2007 Access (the mdb file format) is I can
control everything in one nice, neat package. I can certainly conceptualize
creating my own security model for my UI objects but that's going to be a
major pain!!! Am I missing something here? Is there another option?

Thanks for your help.
 
G

Guest

Sorry for posting my earlier message before reading some of the other
threads. It appears this issue has been knocked around quite a bit and I
should probably look into some of the previous suggestions before commenting
further.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Security - Conversion 3
Access 2007 Security/Users/groups etc. 3
User Level Security & Access 2007 2
Users in Access 2007 2
Access 2007 Security? 2
How khow who created or updated a record in access 2007? 1
Digital Signature Problem 8
Which version of Access should I set up my Security In 1

Top