Restrict access to a database

[VBonliner]

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..

[VBonliner]

Tyhanks RobIII... I'll do the first option (put a
password in my code)

[VBonliner]

Anyone knows how to provide an Access password
thru VB code? Thanks. Password="NoFigureOut"