FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the Access Adapter , which may answer your question: CSV import , generate test data , automated batch CSV import
  • Page:
  • 1

TOPIC: Access Adapter and Workgroups

Access Adapter and Workgroups 4 months 2 weeks ago #3504

  • Brad Weaver
  • Brad Weaver's Avatar Topic Author
  • Offline
  • Posts: 1
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.

Access Adapter and Workgroups 4 months 2 weeks ago #3505

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:
The following user(s) said Thank You: Brad Weaver

Please Log in or Create an account to join the conversation.

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.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en