Solved

Protect Access 2016 database with password

Posted on 2016-09-25
6
95 Views
Last Modified: 2016-09-28
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
Comment
Question by:Moshe Singer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 38

Expert Comment

by:PatHartman
ID: 41815320
If you include the password in the command line, how does that protect the database?
0
 
LVL 12

Expert Comment

by:Máté Farkas
ID: 41815535
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
 

Author Comment

by:Moshe Singer
ID: 41816230
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 2

Accepted Solution

by:
Saadia Attias earned 500 total points
ID: 41817942
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
 

Author Comment

by:Moshe Singer
ID: 41820146
how i use to code to Unset Database Password?
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 41820351
Try starting a new question.  This one is closed.
0

Featured Post

Automating Your MSP Business

The road to profitability.
Delivering superior services is key to ensuring customer satisfaction and the consequent long-term relationships that enable MSPs to lock in predictable, recurring revenue. What's the best way to deliver superior service? One word: automation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question