General discussion

Locked

Microsoft Access Database Encyrption

By ctapper ·
I have been using a Microsoft Access Database in my Visual C++ program. A new requirement has been raised which requires that the Database be encrypted in some way. I have tryed placing a password on the database, but to no avail. Does anyone know how to get this to work, or any other way I can encrypt the database, but still be able to read and write to it from my code?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Microsoft Access Database Encyrption

by un_known_one In reply to Microsoft Access Database ...

I find the help wizard to be an effective tool for most questions. In MS Access use the wizard (help) to answer this q.--according to this tool
on a new database: On TOOLS menu point to SECURITY click ENCRYPT/DECRYPT DATABASE You'll probably be able to do pretty much the same with a current database -- check help file. YOU CANN"T encrypt/decrypt a database when it is open. If you can't do this on your current database open a new database and do the e/d then import the one you want to e/d. Hope this helps -- :) if not maybe someone else will be able to assist you

Collapse -

Microsoft Access Database Encyrption

by ctapper In reply to Microsoft Access Database ...

I had no problem adding or removing a password to and from the database. I also could not use the help wizard since my problem was in implementing the password in my Visual C++ code.
I know longer require an answer however since my co-worker recieved one back from another tech site. Thanks anyway.

Collapse -

Microsoft Access Database Encyrption

by donq In reply to Microsoft Access Database ...

I think you are trying to do the wrong thing.

Encryption is a process where logical patterns are removed from a stored FIELD OBJECT - not an entire database.

If you need security you'll need to define a Workgroup, Join it, restare the computer, start the computer and define and implement User Level securtiy.

If you need an Access 97 database protected you'll need to purchase the Access 97 ADT, Access Developer Toolkit and turn your ".mdb" file into a ".exe" file. Depending on the sizeof your database you can add around 18MB to the ".exe" file that is created because users no longer need Access to run your database.

If what is sacred is the data inside the database create Encrypted fields and/or User level security BEFORE generating an executable.

Hope this helps. Don Quigg

Collapse -

Microsoft Access Database Encyrption

by ctapper In reply to Microsoft Access Database ...

This was not what I needed as well. If anyone ever has a similiar problem, heres what fixed our problem:

I simply had to change one line of code when opening the database. The password couldn't be specified straight forward, instead it had to be prefixed with Jet OLEDB:Database Password=.

Collapse -

Microsoft Access Database Encyrption

by ctapper In reply to Microsoft Access Database ...

This question was closed by the author

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums