TOPIC:

Access Adapter and Workgroups 2 years 8 months ago #3504

Brad Weaver 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 2 years 8 months ago #3505

FlowHeater-Team
Offline
Posts: 386

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.

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