Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

Protect Access 2016 database with password

I encrypted the database with a password, however, I want to be able to open the database with a command line which should include the password, because I see no other way to protect the application except for using a password. Does anyone have a suggestion how I can include the database password in the command line?
0
Moshe Singer
Asked:
Moshe Singer
1 Solution
 
PatHartmanCommented:
If you include the password in the command line, how does that protect the database?
0
 
Máté FarkasDatabase Developer and AdministratorCommented:
Yes it is possible to provide the password when you open the database file in Access:

C:\<path to office>\MSACCESS.EXE /pwd <password> YourDatabase.mdb

Open in new window

0
 
Moshe SingerAuthor Commented:
thanks Mate Farkas
if you try this, you will see that  it is not possible
"pwd" is not working for a "Database Password"


And for PatHartman
the Command line I can close in many ways, it can be a vb project, and some other ways
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Saadia AttiasNetwork & Security Engineer / Dev Pro AccessCommented:
May be try to use this code each time to want to open the database.
It is not a command shell one but you can set it on the database and let autoexecute it each time you will open it.
Good luck

Public Sub SetDatabasePasswordRunCmd(strSourcePath As String)

    ' Define Variables
    Dim accApp As New Access.Application
 
    ' Open the Source database in Exclusive mode
    accApp.OpenCurrentDatabase strSourcePath, True
 
    ' Invoke the "Set/Unset Database Password" dialog
    accApp.DoCmd.RunCommand acCmdSetDatabasePassword
 
    ' Cleanup Variables
    accApp.Quit acQuitSaveNone
    Set accApp = Nothing
 
End Sub
0
 
Moshe SingerAuthor Commented:
how i use to code to Unset Database Password?
0
 
PatHartmanCommented:
Try starting a new question.  This one is closed.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now