Cannot connect to Access DB

[hcl-bot]

I am trying to setup DECS to connect to an Access DB on another machine on our network.

Using OLE DB, I fill out the connection section and then when I click on the Owner or Name button in the “Table/View Section” I get this error.

Cannot start your application. The workgroup information file is missing or opened exclusivly by another user.

I’m probably just completely missing something here? Does the Access Db have to be on the same machine?

If anyone has had experience in connecting to an Access DB I’d appreciate any suggestions you may have

Thanks

[hcl-bot]

Subject: Cannot connect to Access DB

One thing I found when using OLE DB is I had to ensure I had the latest MDAC downloaded & installed from the Microsoft Website. It may or may not help but worth a try.

Here’s a link to it:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Regards,

Alex

AGECOM