Re: How to secure an Access database.

From: robher (anonymous_at_discussions.microsoft.com)
Date: 05/16/04 

Date: Sun, 16 May 2004 14:11:05 -0700

Maybe I wasn't too clear on what I'm trying to do.

I know how to create users and assign passwords and permissions to an Access database. I've read the document a few times, but that's not the kind of security I'm talking about. It takes about 5 minutes to find an Access password cracker on the internet.

What I'm trying to achieve is that users can't access the folder where the .mdb file is located. That kind of security is far better. Like I explained in my previous posting, the way I plan to do that is to have the VB application impersonate another user when opening the ADODB connection. My only problem is I can't figure out how to impersonate the user ONLY when opening the connection and not for the rest of the program.