| |
Customer
I have created a secure database with mdbsecure, and everything seemed
to work fine, but when I try to open the database and I put in the
password I get the message that "You do not have necessary permissions
to open the dababase (blah)".
Also, the prompt that
comes up just invites me to enter a database password, not a username -
shouldn't access ask me for both? Perhaps you could tell me what I am
doing wrong?
|
Support
You need to specify the workgroup file at the command line or specify
the workgroup file created by MDBSecure as the default workgroup file.
You'll also need to specify the Username (you can also specify the password) as the command line.
MDBSecure has an open database feature, which spawns MS Access.
However, the ideal way to open a secured database in via a programming language, then you can specify everything in code.
|
Customer
So just to confirm, the only way to open a secured mdb file without
writing the password down somewhere that people can find it (either in
a shortcut or batch file) is to build a programmatic extension?
Actually this suits me, because I was planning this kind of approach, but it would be interesting to have this confirmed.
|
Support
Yes.
We've recently had an email asking how you can open the secure database once created by MDBSecure.
From within Windows, You can either use the command prompt (or from the start menu, Run) or use a batch file.
Heres a sample batch file.
Code:@Echo off
Echo Usage: Access.exe db-file /wrkgrp workgroup-file /user Super-User-Name /pwd database-password /Excl
Echo .
echo Once run Access will ask you for the User Password
Echo .
Echo Press Any key to open DB
Pause
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" c:\temp\temp.mdb /wrkgrp c:\temp\temp.mdw /user Stephan /pwd Klara /Excl
|
|
|
|
