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=Micro soft.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]

Re: Error accessing Access DB

Hi Kev,

Try one of the connectionstrin gs on www.connectionstrings.com

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



On Mon, 09 Oct 2006 13:00:21 +0200, Mantorok <mantorok@manto rok.comwrote:

Hi all
>
I'm trying to connect to an Access db that uses workgroups, here is the
connection string:
>
"Provider=Micro soft.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
>
>

--
Happy Coding!
Morten Wennevik [C# MVP]

[Mantorok]

Re: Error accessing Access DB

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

Kev

Hi Kev,
>
Try one of the connectionstrin gs on www.connectionstrings.com
>
Your password seem to be missing a : after Jet OleDB and a ; at the
end
>
On Mon, 09 Oct 2006 13:00:21 +0200, Mantorok <mantorok@manto rok.com>
wro te:
>

>Hi all
>>
>I'm trying to connect to an Access db that uses workgroups, here is
>th
>>

e
>

>connection string:
>>
>"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=database .mdb;Jet
>>
>OLEDB:System Database = system.mdw;User Id=infadmin;Jet OLEDB Data
>>

base
>

>Password=***** *"
>>
>The error is: "not a valid account name or password."
>>
>I've confirmed the user id and password, any ideas?
>>
>Kev
>>

Kev

[Morten Wennevik]

Re: Error accessing Access DB

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;

--
Happy Coding!
Morten Wennevik [C# MVP]

[Mantorok]

Re: Error accessing Access DB

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

Kev

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,
substitutin g
>
system.mdw with the correct file, if needed.
>
Jet OLEDB:System Database=system .mdw;
>

[Morten Wennevik]

Re: Error accessing Access DB

I'm afraid I'm out of ideas.

Try the newsgroups

microsoft.publi c.access
microsoft.publi c.access.securi ty
microsoft.publi c.dotnet.framew ork.adonet



On Mon, 09 Oct 2006 13:57:14 +0200, Mantorok <mantorok@manto rok.comwrote:

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

>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,
>substitutin g
> system.mdw with the correct file, if needed.
> Jet OLEDB:System Database=system .mdw;
>>

>
>

--
Happy Coding!
Morten Wennevik [C# MVP]

[sloan]

Re: Error accessing Access DB

The connection string is super anal.

Every space , semi colon must be perfect.

You also need to try the different versions at connectionstrin gs.com

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

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


"Mantorok" <mantorok@manto rok.comwrote in message
news:cbb45a82ef 908c8b9b1a14a3f 29@news.rmplc.c o.uk...

Hi all
>
I'm trying to connect to an Access db that uses workgroups, here is the

connection

string:
>
"Provider=Micro soft.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
>
>