Accessing secured database 2000 vs 2003

[rwn]

I'm trying to open up an access database that is secured. In a 2003 database the statement is as follows:

Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Database.mdb;" & _
"Jet OLEDB:System Database=C:\Security.mdw;" & _ "User ID=admin;" & _
"Password=1234;"
and the file opens just fine.

However in a 2000 access database the statement is this and does not open.

Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Database.mdb;" & _
"Jet OLEDB:System Database=C:\Secured.mdw;" & _ "User ID=admin;" & _
"Password=1234;"

I've even converted the access 2000 to access 2003 and still do success in opening the file.

Any thoughts?

 

[JerryKlmns]

Open your 2000 database. In immediate window try this
?syscmd(acSysCmdGetWorkgroupFile)

and check the value if it matches with this
Jet OLEDB:System Database=C:\Secured.mdw

I see your 2003 version uses this one
Jet OLEDB:System Database=C:\Security.mdw;

BTW, you dont mention any error message and you posted in a wrong forum. Better try forum705