|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 16th, 2006, 08:44 PM
|
|||
|
|||
|
Using an access db
Hi imtrying to access my access db wich is password protected from vb6
Set db = OpenDatabase(App.Path & "\datbwc.mdb") this is the string i was using till i set the password now im lost as what to do. or where to put the password info
|
|
#2
May 16th, 2006, 11:27 PM
|
|||
|
|||
|
This string should be what you are looking for:
Set db = OpenDatabase(App.Path & "\datbwc.mdb", False, False, "ODBC;pwd=mypassword") You have to specify that parameter 2 and 3 are False, otherwise if you just try to leave them out it reads "ODBC..." as parameter 2 and will throw up a nasty error.
|
|
#3
May 18th, 2006, 04:36 PM
|
|||
|
|||
|
error '3151'
I get an error that says the odbc connection faild
|
|
#4
May 19th, 2006, 03:28 AM
|
||||
|
||||
|
Try something like this:
Code:
Set db = New ADODB.Connection
With db
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
.CursorLocation = adUseClient
.Open
End With
Check out www.connectionstrings.com, it does exactly what it says on the tin!!!
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Using an access db |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
