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. So I can use the
recordsets to fill e.g. a combo-box.

I'm using AccessXP.

Thanks,

Jan Alsenz

 

[Jan Alsenz]

Hi,

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>

I guess this works with all data-providers and arguments,
but I haven't tried.

Regards,

Jan Alsenz