Code connect to database and query select data from database in Ms Access 2007 (1 Viewer)
- Thread starter veasna
- Start date
Hi Veasna,
You can find the correct connection string to connect to your database at:
http://www.connectionstrings.com/
They list connection strings to any database you need!
-Diana
You can find the correct connection string to connect to your database at:
http://www.connectionstrings.com/
They list connection strings to any database you need!
-Diana
Hi Veasna,
For Access 2007 standard security string:
If your database has a password:
-Diana
For Access 2007 standard security string:
Code:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;If your database has a password:
Code:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;-Diana
