Hello,

I'm trying to open a connection (ADO) via the
Microsoft.Access.OLEDB.10.0 provider to a mdb-file wich
has a custom mdw-file (the same as the file I'm
connecting from).
My problem is how can I pass the mdw-file to the
Microsoft.Jet.OLEDB.4.0 data-provider.

I'm using AccessXP.

Thanks,

Jan Alsenz

Either add this key-value pair to the connection string or to the Properties
collection

Jet OLEDB:System Database = <path to workgroup info file.mdw>



"Jan Alsenz" <(E-Mail Removed)> wrote in message
news:05c301c34783$40a6d8b0$(E-Mail Removed)...
> Hello,
>
> I'm trying to open a connection (ADO) via the
> Microsoft.Access.OLEDB.10.0 provider to a mdb-file wich
> has a custom mdw-file (the same as the file I'm
> connecting from).
> My problem is how can I pass the mdw-file to the
> Microsoft.Jet.OLEDB.4.0 data-provider.
>
> I'm using AccessXP.
>
> Thanks,
>
> Jan Alsenz

Hi,

thanks for the answer, but I'd already tryed that. This
works only when the provider is "Microsoft.Jet.OLEDB.4.0"
and not if the provider is "Microsoft.Access.OLEDB.10.0"
with data-provider "Microsoft.Jet.OLEDB.4.0".
But I worked it out.
You can pass properties to the data-provider by using:

Connection.Properties("Extended Properties").Value = "Jet
OLEDB:System Database=" + <path to workgroup info
file.mdw>

Regards,

Jan Alsenz

>-----Original Message-----
>Either add this key-value pair to the connection string
or to the Properties
>collection
>
>Jet OLEDB:System Database = <path to workgroup info
file.mdw>