user/password?

[Guest]

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\...\mydb.mdb

I can't find the syntax for adding a user and password to this string. Could you point me to the help/manual file? I'm using Access 2003 on a db that was created under Access 2000. I assume it is backward compatible?

Thanks

 

[Douglas J. Steele]

The best reference I know of for Connection strings is Carl Prothman's
http://www.able-consulting.com/ado_conn.htm

According to
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDB
ProviderForMicrosoftJet it's


oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:System Database=MySystem.mdw", _
"myUsername", "myPassword"


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\...\mydb.mdb

I can't find the syntax for adding a user and password to this string.

Could you point me to the help/manual file? I'm using Access 2003 on a db
that was created under Access 2000. I assume it is backward compatible?

 

[TC]

Google says (for example):

szConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"DataSource=" & ActiveWorkbook.Path + "\SALES;" & _
"Jet OLEDB:System Database=MySystem.mdw" & _
"UserID=admin; Password=123;"

HTH,
TC

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\...\mydb.mdb

I can't find the syntax for adding a user and password to this string.

Could you point me to the help/manual file? I'm using Access 2003 on a db
that was created under Access 2000. I assume it is backward compatible?

 

[TC]

oops, I just replied to him with one of your own examples!

Must read whole thread ... Must read whole thread ...

TC