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

Help with conecction please

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+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Like this:

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

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/uYnYechKqOuFEgEQLAJQCeOlzCkOPmHlLr1vHzQkA7IF3FPJ4A nRCS
5EI/HKnkudAQxrgfUxvAw3vO
=TyQO
-----END PGP SIGNATURE-----
Enrique wrote:
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 #2

This discussion thread is closed

Replies have been disabled for this discussion.