Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Access Adapter and Workgroups

More
5 years 1 month ago #3504 by Brad Weaver
Access Adapter and Workgroups was created by Brad Weaver
I have a client Access Database that is linked to Access workgroup security.  How do I open the tables in the database from Flowheater?  I've tried connecting and when I enter a valid password from the workgroup I get an error message that I do not have rights to access the database.  In order to open it from Access, I have to use a workgroup parameter in my startup field of my shortcut.

Please Log in to join the conversation.

More
5 years 1 month ago #3505 by FlowHeater-Team
Replied by FlowHeater-Team on topic Access Adapter and Workgroups
Hi Brad,

To connect to an Access database with workgroup security settings you have to use the  OleDB Adapter instead of the Access Adapter .

For “OleDB data source” you have to use the following connection string.

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\database.mdb; Jet OLEDB:System Database=D:\system.mdw; User ID=Username; Password=TopSecret;

With this, you can specify the system database location of the workgroup security MDW file.
 

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:

Please Log in to join the conversation.

Time to create page: 0.272 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.