Run-time error 2147217843 (80040e4d) connecting to external database

[vspargo]

I'm trying to add a field to a secured external database using VBA (it's the back end of the one the code is running in). Both databases are Access 2002 OS=Windows XP.

The error tells me I'm using an incorrect Account Name or Password, but they are correct.

cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=c:\...\Data.mdb;Jet OLEDB:System Database="&_
"c:\...\Secured.mdw;UserID=Me;Password=abc;"

The rest of my code works if I use it on an unsecured database, it's just the security connection that I'm having trouble with.

Before I added the System Database reference I was getting the same error number telling me the Workgroup file was in use or missing.

Please help!

[MMcCarthy]

Try this ...

cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=c:\...\Data.mdb;Jet OLEDB:System Database="&_
"c:\...\Secured.mdw;Password=abc"

I've dropped the semi-colon at the end of the statement and removed the UserID reference.

Mary