DataShape with JET and SystemDatabase

[Frank Schlüter]

Hello,

i want to open a ADO-Connection on a MS Jet-Database for hierachical
recordsets. Provider is "MSDataShape", DataProvider is
"Microsoft.Jet.oledb.4.0". But how can I define the path to the mdw-File?

Can you help me?
Frank

 

[Dan Artuso]

Hi,
Have you tried something like this:

"Provider=MSDataShape.1;Data Source=c:\Windows\Desktop\NewsgroupTesting.mdb;" & _
"Connect Timeout=15;Data Provider=MICROSOFT.JET.OLEDB.4.0;" & _
"Jet OLEDB:System Database=MySystem.mdw", _
"myUsername", "myPassword"

 

[Dan Artuso]

Hi,
Sorry, the message is in German so I have no idea what it says!
Also, I don't usually open attachments, so just explain it as best you can.

 

[Frank Schlüter]

Hello
Its over, i fixed it. The message means that the database is opened by
myself in a status, that i cant save Changes. Only MS know what this means.
But now i open a connection first, leave it open until the user quits the
program and use the connection when i need it. not well but it works. Thank
for your postings, maybe i can help you later.

Frank