dbTalk Databases Forums  

Visual Basic 6.0 Connection

comp.database.ms-access comp.database.ms-access


Discuss Visual Basic 6.0 Connection in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oin Zea
 
Posts: n/a

Default Visual Basic 6.0 Connection - 01-30-2005 , 01:38 AM






I have been trying to connect to an .mdb file protected by a password
created using Access 2003.

I fond some information on Microsof DAO Database:
The connect argument is expressed in two parts: the database type, followed
by a semicolon ( and the optional arguments. You must first provide the
database type, such as "ODBC;" or "FoxPro 2.5;". The optional arguments
follow in no particular order, separated by semicolons. One of the
parameters may be the password (if one is assigned). For example:

"FoxPro 2.5; pwd=mypassword"
My Code is:Set dbsC = OpenDatabase(Path + "\C.mdb",,,"ODBC;
pwd=mypassword")This will result in Run Time Error 3031: Not a valid
passwordHelp Anyone plz!




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.