Access 2010 create login and password

Hi

I have to manually set a login and password so that I can access an Access database with the following code;
connectionString="Microsoft.ACE.OLEDB.12.0;Data Source=Database\Contacts.accdb;User Id=myLogin;Password=myPass;" />
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
You don't need to specify the user id an password unless your database is protected. If you haven't specified a username and password for the database you can simply remove those two elements from the connection string.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.