Solved

VB4 to Access DB security

Posted on 1998-08-23
1
163 Views
Last Modified: 2011-04-14
I am using a vb4 data control to open a .mdb file that has a database password set (not user level).  I get an 'invalid password' error in trying to access the database.  how do i inform the db of the password using the data control.  If there is no way to do it with the data control, is there a way to do it DAO.  thank you in advance.
0
Comment
Question by:svfafel
1 Comment
 
LVL 9

Accepted Solution

by:
Dalin earned 50 total points
ID: 1430589
svfafel
Try this: Let me know if any problem

With Data1
DatabaseName=App.Path & "\my.mdb"
RecordSource="mytable"
Connect=";Pwd=" & pwd
Refresh
End With

Regards
Dalin
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

679 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