Error accessing Access DB

[Mantorok]

Hi all

I'm trying to connect to an Access db that uses workgroups, here is the connection
string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;Jet OLEDB:System
Database = system.mdw;User Id=infadmin;Jet OLEDB Database Password=******"

The error is: "not a valid account name or password."

I've confirmed the user id and password, any ideas?

Kev

 

[Morten Wennevik]

Hi Kev,

Try one of the connectionstrings on www.connectionstrings.com

Your password seem to be missing a : after Jet OleDB and a ; at the end

 

[Mantorok]

Ok, I've confirmed the connection string but I'm still getting the same error....

Kev

Hi Kev,

Try one of the connectionstrings on www.connectionstrings.com

Your password seem to be missing a : after Jet OleDB and a ; at the
end

Kev

 

[Morten Wennevik]

I won't claim to know much about Access, but a quick google seemed to
indicate that this might be related to the workgroup id file.

You may need to specify this file in your connection string, substituting
system.mdw with the correct file, if needed.

Jet OLEDB:System Database=system.mdw;

 

[Mantorok]

Ok, I've tried that as well, but I still get the same message :-/

Kev

 

[Morten Wennevik]

I'm afraid I'm out of ideas.

Try the newsgroups

microsoft.public.access
microsoft.public.access.security
microsoft.public.dotnet.framework.adonet

 

[sloan]

The connection string is super anal.

Every space , semi colon must be perfect.

You also need to try the different versions at connectionstrings.com

Personally, I've never used the system.mdw thing.

Also, try a fully qualified path name for the mdb file
Data Source=c:\mydatabase.mdb