connection to secured acces db from excel using ado

[Reinier11]

Hi all,

Can anyone help with setting op an ado-connection from an excel spreadsheet to a secured access db? The db is secured so the user needs to be joined with the security workgroupfile, but how is this done through ado?

Greetz,
Reinier

 

[Reinier11]

Hi,
I found part of the solution at Microsoft Knowledge Base Article - 191754, but I get the message:"the workgroup file is missing or opened exclusively by another user."
Currently absolutely no one is in it, so how can this be?

Gr,
Reinier

 

[Reinier11]

Hm, found it myself, it was just a typo