I developed a small windows appln in vb.net 2005 which uses MS-Access2003 as backend
I want to give my own protection to this MS-Access file
when i try open the access file, it should display my own Enter password dialog box for password
I also want to mainain the user credentials in this access file
Can we do this in VBA
can we do this in vba
C57682
Hi,
You shouldn't need to use VBA. If you load your database and select Tools->Security->Set Database Password... you can set a password, which I believe you can pass to the database through the connection string.
If this isn't suitable then you can create your own login using VBA. Create a login form and set it as the startup form of the database. You need to disable all the menus and special keys so that there isn't a workaround.