How can I add an Access DB to my C# project when it requires an MDW file too?

Question

I want to use an Access database file in my C# project. When I add it as a new Data Source all goes well until I try to test the connection. Then I get the message:

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

The file is password protected and an MDW file is used. So how can I add the file as a data source and use the workgroup info file as well?

Thanks

What is your connection string? The MDW location can be specified there. — D'Arcy Rittich
– D'Arcy Rittich, Commented Sep 29, 2012 at 0:22
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\newUser_be.mdb;User ID="Jim" But it wont let me edit the connection string. Unless its done some other way... — JimDel
– JimDel, Commented Sep 29, 2012 at 0:24

D'Arcy Rittich · Accepted Answer · 2012-09-29 00:26:45Z

5

Here is an example connection string specifying where the .MDW file is located:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;
    Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;

answered Sep 29, 2012 at 0:26

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JimDel Over a year ago

Thanks RedFilter! That was what I needed/

Collectives™ on Stack Overflow

How can I add an Access DB to my C# project when it requires an MDW file too?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related