-
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.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
|
Time to create page: 0.139 seconds