Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reading a .mdb file with VB6

Posted on 1999-01-03
1
Medium Priority
?
590 Views
Last Modified: 2012-06-27
How can I read a simple .mdb file with VB6 that is password protected. All user permissions are set to default and I can read it fine if there is no password without using any code. When I add a password to the Access database, my VB app can't access it anymore. Any ideas??
Albert
0
Comment
Question by:ahammar
1 Comment
 

Accepted Solution

by:
Ajoy earned 300 total points
ID: 1453668
ahammar,
u can set up a connection string with  the userID and Password.
Then set up the conection to the database with this connection string.this should work.
eg:
dim sCnn as string
scnn = "{rsDbdriver}, ServerName,databasename,TableName,UsrID Password"
use this string(scnn) to establish connection  with the .mdb file
regards,
ajoy

my mail ID is :
Ajoy.Tarafder@in.bosch.com
u can mail me at the address mentioned and i will try to help u out

0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…
Suggested Courses

927 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