connecting to mdw protected database

[Jan Alsenz]

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

 

[Mike M]

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]

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>