Access - changing database password from an EXE
-
Hi, I need to write a small program that backs up a Microsoft Access database in a specific way, and wondered if anybody here could offer me a little help. Basically, this is what the program needs to do: 1) Copy the original database (.mdb file) to a different folder (the backup folder). 2) Change the database password of the backed up version (the backup needs a different password). 3) Set the properties of the backed up password to "Read-only". 1) and 3) are easy, but 2) is giving me problems. At the moment I have to do this manually at the end of each day - by opening the copy using "Exclusive access", unsetting and then resetting the database password. Essentially I just want to write a program to automate this process and save me time at the end of each day. I am hoping that there is some way to automate step 2. If this is a really basic question, please accept my apologies. I have written a few basic C/C++ and WinAPI programs, but I have never interfaced with Access from another program. Many thanks for any help or pointers, KB
-
Hi, I need to write a small program that backs up a Microsoft Access database in a specific way, and wondered if anybody here could offer me a little help. Basically, this is what the program needs to do: 1) Copy the original database (.mdb file) to a different folder (the backup folder). 2) Change the database password of the backed up version (the backup needs a different password). 3) Set the properties of the backed up password to "Read-only". 1) and 3) are easy, but 2) is giving me problems. At the moment I have to do this manually at the end of each day - by opening the copy using "Exclusive access", unsetting and then resetting the database password. Essentially I just want to write a program to automate this process and save me time at the end of each day. I am hoping that there is some way to automate step 2. If this is a really basic question, please accept my apologies. I have written a few basic C/C++ and WinAPI programs, but I have never interfaced with Access from another program. Many thanks for any help or pointers, KB
You might try posing question #2 to the folks in the Access section at http://www.mvps.org/[^].
A rich person is not the one who has the most, but the one that needs the least.