VB tries to Open MS Access DB [ERROR] 
Author Message
 VB tries to Open MS Access DB [ERROR]

I'm using a dataenvironment in VB6. I want to open a password
protected MS Access 2K DB without code, just using the vb6
functionalities of the DEnv. I have tried many things, always getting
the same error. I'm placing the correct password on the connection
field were the password should be. The User is Admin. I thing a lot of
ppl out there have run into the same problem. But, I haven't been able
to find an accurate answer on Searchers nor MS msdn.

Any help or hint will be greatly appreciated

Thanks a LOT for your time



Tue, 13 Dec 2005 20:23:34 GMT  
 VB tries to Open MS Access DB [ERROR]

I'm using a dataenvironment in VB6. I want to open a password
protected MS Access 2K DB without code, just using the vb6
functionalities of the DEnv. I have tried many things, always getting
the same error. I'm placing the correct password on the connection
field were the password should be. The User is Admin. I thing a lot of
ppl out there have run into the same problem. But, I haven't been able
to find an accurate answer on Searchers nor MS msdn.

There are two types of Access security, user-level and database password. If you're using a simple
database password then you do not need to specify the user ID and user ID password. The article
below contains some examples of connection strings that implement both user-level and database
password security:

HOWTO: Open a Secured Access Database in ADO Through OLE DB
http://support.microsoft.com/default.aspx?scid=http://support.microso...


Microsoft MVP (Visual Basic)



Tue, 13 Dec 2005 23:16:40 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB tries to Open MS Access DB [ERROR]

2. App tries to open DB as MS Access 1.1 fmt instead of 2.0

3. Mail merge from Access try to open an already open DB

4. Jet error trying to open a db on another machine in a W98 network

5. Jet error trying to open a db on another machine in a W98 network

6. Error trying to open MS Word

7. Error trying to open MS Word

8. Please help in VB 4.0 trying to access MS access 7.0 forms and reports

9. Can set a ref to 1 open db but not another open db - error 3045

10. Error 536 (Incorrect logon parameters) when trying to logon to a access-db via PELogonServer

11. Error when trying to save a BMP file from image control in an Access 97 db

12. Weird ASP error when trying to add a new record to a MS Access database

 

 
Powered by phpBB® Forum Software