FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the Access Adapter , which may answer your question: CSV import , generate test data , automated batch CSV import

Access Adapter and Workgroups

  • Brad Weaver
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months 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 or Create an account to join the conversation.

More
3 years 11 months 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 or Create an account to join the conversation.

Time to create page: 0.290 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en