Dear Access members,

Could you tell me to code connect to database and the query to select a field of data from database?

Thanks,

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

Hi Veasna,

For Access 2007 standard security string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

If your database has a password:


Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;

-Diana