Avoid access in .mdb 1

[groner]

Hi pople !
I have made a database using VB6 with VisDataManager support . I want to avoid that the user to open the database using MS Access programme or other .
How can I restrict the access to open this (.mdb) database .
Thank you for any sugestion .

 

[flyboytim]

see my post in thread181-498717

 

[LazyMe]

Can't it just be password protected ?
Greetings,
Rick

 

[petermeachem]

Just rename it so that the file extension is not mdb. That fools most people.

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[CCLINT]

Set a password for the MDB and then after setting the provider, and just before openning the connection, add theis line:

conn.Properties("Jet OLEDBatabase Password&quot = "1234abcd"

or in the open method of the connection object, add:

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myDB.Mdb;Jet OLEDBatabase Password = 1234abcd"

 

[BlackburnKL]

How about encrypting the .mdb file itself?

I'm not referring to using Access's encryption, but rather file encryption. I have done this and in my limited experience with it, it works well.

I would recommend changing the file extension from .mdb to something else, although Access will not like the format even if they tried to open it with Access. BlackburnKL

 

[groner]

For BlackburnKL .
How can I do this ?

 

[groner]

For CCLINT .
My experience in DataBases it's limited .
I'm work with this code :
Dim myDB As DataBase
Set myDB = OpenDataBase(AppPath)
....
What must be change or append ?

 

[groner]

For everybody.
How can i protect one file (for example one DB) to delete them from the computer .

 

[VBOldTimer]

"What must be change or append"

Open password protected mdb:

Set myDB = DapenDatabase(AppPath & "\myData.Mdb",False,False,";pwd=XYZ789&quot

Change Password:
myDB.NewPassword = "ABC123"

 

[VBOldTimer]

"How can i protect one file"

Maybe just hide it?

SetAttr App.Path & "\myData.MDB", vbHidden

 

[BlackburnKL]

We downloaded one from the internet. I don't remember where we got it, but I can e-mail it to you. You can contact me at BlackburnKL@LDSChurch.org. BlackburnKL