By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Maybe a stupid question

P: n/a
i am learning how to use adodb and i am trying to conect a form to
another database mdb, but when i use a password in that database i
cant acces to it because i dont know how to do it, i try like this

..ActiveConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"data source = c:\time aware\time aware data.mdb;"

it works when the database is with out password, when i use password
wont
if the user is Admin and the password is 123456 how should i write it?
x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 800 Gigs/Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Enrique <en****@hotmail.com> wrote in message news:<ju********************************@4ax.com>. ..
i am learning how to use adodb and i am trying to conect a form to
another database mdb, but when i use a password in that database i
cant acces to it because i dont know how to do it, i try like this

.ActiveConnection = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"data source = c:\time aware\time aware data.mdb;"

it works when the database is with out password, when i use password
wont
if the user is Admin and the password is 123456 how should i write it?


See:
http://www.able-consulting.com/MDAC/...orMicrosoftJet

(watch the wrap!)

If using a Workgroup (System Database)

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:System Database=MySystem.mdw", _
"myUsername", "myPassword"
Note, remember to convert both the MDB and the MDW to the 4.0
database format when using the 4.0 OLE DB Provider.
If MDB has a database password

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:Database Password=MyDbPassword", _
"myUsername", "myPassword"
Nov 12 '05 #2

P: n/a
Pieter thanx for the info and the link, i did it and works

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.