VB.NET Access connection string with credentials

Question

I'm trying to connect into an Access 2010 database via a network share and I want to supply the credentials. The below string is not working; it brings back a "Could not find installable ISAM" error.

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\192.168.xx.xx\Custom Tools\Tracker.accdb;Uid=admin;Pwd=;"

Well, this works fine if I take the username/pw part out. If I open up the share first and authenticate, then just connect in without the UID/PW, it opens and displays with no issues. But I want to always authenticate first so I don't have to worry about it later. — DominicD74
– DominicD74, Commented Oct 5, 2015 at 12:42
The .accdb file format does not support User-Level Security (ULS), so supplying a username and password in the connection string really doesn't make any sense. If you need credentials to access the server share you will probably need to establish a connection to the server before you try and connect to the database. — Gord Thompson
– Gord Thompson, Commented Oct 5, 2015 at 14:49

tgolisch · Accepted Answer · 2015-10-05 13:19:20Z

1

You only need to force server authentication if your computers are not on a domain. For example, if your MSAccess DB is on a P2P network or a server that is not on your domain.

In that case, one simple option is to require each user to have a drive mapped to your \192.168.xx.xx server (mentioned above). That will force authentication when the user logs-in to a PC.

answered Oct 5, 2015 at 13:19

tgolisch

6,7743 gold badges27 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

VB.NET Access connection string with credentials

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related