Home > Access > Connection String Untuk Access 2007

Connection String Untuk Access 2007

Standard security

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

With database password
This is the connection string to use when you have an Access 2007 database protected with a password using the “Set Database Password” function in Access.

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

DataDirectory functionality

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Persist Security Info=False;

source: connectionstrings dot com

Categories: Access Tags: , ,
  1. October 25, 2010 at 10:34 am

    buat irfan…………
    okey LaH……….

  2. May 23, 2012 at 11:25 pm

    Mas .,.,klo koneksi dri visual basic ke database access 2007 untuk cetak laporan crystal report gmana kode’a???

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: