Hi,
How can I deny access to an Access database from
outside a VB application? i.e. The database can
only be accessed through the application.
Printable View
Hi,
How can I deny access to an Access database from
outside a VB application? i.e. The database can
only be accessed through the application.
- Try putting a password on it (Access 97 & 2000 support this, I just don't know exactly how)
- Try encrypting the file
- Change the extension (.mdb) to (.noa <-NoAccess ;) )
First method is safest,
Second method would involve decrypting it to a .tmp file or so to work with it then on program close encrypting it again...
Third method is for computer-illiterates... If you'd rename it back to .mdb just a double click would open it. Also, you could open it in access as "All Files".
Maybe there are more options, I dunno..
Tyhanks RobIII... I'll do the first option (put a
password in my code)
Anyone knows how to provide an Access password
thru VB code? Thanks. Password="NoFigureOut"