Access to Access

[VBonliner]

Hello,

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.

[HunterMcCray]

Originally posted by VBonliner
Hello,

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.

In Access password protect the database. In code when opening the data base provide the password.

Hunter

[VBonliner]

How can I provide the password thru VB code?

[parksie]

Although using a DB password isn't exactly secure:

Anyway, Access97 passwords are stored in the 13 bytes from offset 0x42 in a .mdb file. Do a bitwise XOR with 0x86, 0xFB, 0xEC, 0x37, 0x5D, 0x44, 0x9C, 0xFA, 0xC6, 0x5E, 0x28, 0xE6, 0x13 to recover the plaintext. I think that if the first byte is 0x86, the password is not checked.

[Ober]

Perhaps you should look into a Decryption and Encyption function to encrypt your data.

This will help secure whats in it.

If you use Access97 then it is very vounterable to low level hackers even if you have a password.

Access2000 I have yet to try but I heards a little harder to crack but has been done.

but if you want to put a simple password on your database and still access that through Access then use this code.

Set DB = OpenDatabase(App.Path & "\Alert.mdb", False, False, ";PWD=password")
Set RS = DB.OpenRecordset("Errors", dbOpenDynaset)

If you have anyquestions let me know
OberCanober@Netscape.net

[parksie]

Access2000 passwords are in exactly the same format. :) (I never knew how useful it would be, knowing that, until we got the EAS thing at school ;))