UNIFI UAP Reset to factory settings

Reset AP to factory settings

Lookup the IP address of the AP and login using SSH with Putty

Default username/password:

1

ubnt/ubnt

Execute the AP reset script:

# syswrapper.sh restore-default # mci-cli # set-inform http://YOUR IP:8080/inform Then Adopt AP in the Unifi Controller

Linux - useradd Command

useradd's basic syntax i:

useradd [option(s)] username

The useradd binary (i.e., the ready-to-run program file) is typically located in the /usr/sbin directory. 


Source: http://www.linfo.org/useradd.html

SQL - Create Periode Month+Year

DATENAME(month, TGL) + ' ' + CONVERT (VARCHAR(12), YEAR(TGL))

Files/Folder with spaces on the end - Can't delete files

How to delete folder name with spaces on the end of the filenames in Windows.

Open a command prompt and remove the directory with:

rd /s "\\?\D:\bad\folder\path "

 Done!


Source : https://community.spiceworks.com/topic/273265-files-with-spaces-on-the-end-can-t-delete-files

SQL SERVER - How to Get Number of Days in a Month in SQL Server

To get number of days in the previous month in SQL Server, use the following code:
SELECT DAY(DATEADD(DD,-1,DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)))

To get number of days in the current month:
SELECT DAY(DATEADD(DD,-1,DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 0)))

To get number of days in the next month:
SELECT DAY(DATEADD(DD,-1,DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 2, 0)))

sOURCE : http://zarez.net/?p=2532

Mikrotik - Bridging Networks Point To Point dengan Mikrotik SXT

Bridging Networks Point To Point dengan Mikrotik SXT

Untuk melakukan setting Mikrotik ada beberapa cara, baik menggunakan web dan winbox. Secara defaul IP address untuk RouterBOARDSXT 5HnD adalah 192.168.88.1.

A.    Konfigurasi Akses Point.

Buka Menu:  Wireless ® Interface, Ubah ke Mode AP Bridge. Kemudian buat nama SSID misal : Mikrotik_APMAK, Wireless Protocol : nv2 dan Bridge Mode : Enable

Untuk setting security, pilih tab NV2 ® centang Security dan ketikkan Key yang akan dishared.

a.    Menentukan IP address untuk RouterBOARDSXT 5HnD

Dari menu IP ® Addresses kemudian pilih tanda +

Untuk IP yang terhubung ke local ( ether1-local) menggunakan IP address 192.168.1.150, sedangkan untuk wireless (wlan1-gateway) menggunakan IP 192.168.1.151.

b.    Membuat Bridge untuk menghubungkan Local ke Wireless.

1.    Dari menu Bridge kemudian pilih tanda + pada kolom Name : Wireless Bridge, Type : Bridge. Kemudian klik OK.

2.    Pada baris Wireless Bridge pilih Port, kemudian pada Interface pilih ether1-local pada baris Bridge pilih Wireless Bridge

3.    Ulangi lagi untuk interface wlan1-gateway dan Bridge pilih : Wireless Bridge

c.    Pastikan untuk disable NAT Masquerrade dari menu IP kemudian Firewall

d.    Disable juga DHCP Server, dari menu IP kemudian DHCP Server.

B.    Setting Station Bridge

Pada intinya sama dengan setting AP Bridge, hanya saja pada Mode Wireless ganti menjadi : Station Bridge.

Kemudian Scan untuk mendapatkan SSID dari AP Bridge yg telah disetting sebelumnya.

Source : https://wiki.mikrotik.com/wiki/Bridging_Networks_with_SXT

Linux - Repair /etc/fstab readonly mode

That was very easy to correct fstab from readonly mode. We must mount / in read-write mode.
If /etc/fstab is correct, you can simply type:

mount -n -o remount /

Mikrotik - Block MAC Address

/ip firewall filter
add chain=forward src-mac-address=aa:bb:cc:dd:ee:ff action=drop

How to get 32-bit ODBC drivers for MS Access 2007/2010 on a Windows 7 64-bit System

Found the following off Microsoft’s Website & other Technical Tech-net Forums regarding users having issues setting up ODBC drivers for legacy 32-bit Access databases for shared connectivity to other 32-bit software applications needing to use older ODBC legacy connectivity instead of the newer Jet4.0/OLE.

Issue seen is when going under the normal “32-bit ODBC administrator” found under
Control Panel System & Security Administrative Tools Data Sources (ODBC) – ODBC Data Source Administrator and select “System DSN”
There are not any *.mdb, *.accdb, *.xls or *.xlsx drivers to select from for adding a System DSN –ODBC driver connection, these drivers are missing…only will see one driver for a “SQL Server”(as shown in the captured picture below):

The solution/workaround found on Microsoft/Technet websites recommend to do the following to obtain these ODBC drivers via the “64-bit ODBC Administrator”:



32 bit ODBC driver for MS Access 2010 (*.accdb) is missing in Win7 64bit
If you are running a 64-bit Computer and Running Access 2010, you will first need to download the AccessDatabaseEngine.exe
from Microsoft.
http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
After the download finishes, and installs, You will need to create an ODBC connection. Instead of creating an ODBC connection through your Administrative Tools, Data Sources (ODBC) interface, you will need to run the 64-bit instance of Data Sources (ODBC). To do this, you will need to click your "Windows" + "R" buttons on the keyboard, and then paste "c:\windows\sysWOW64\odbcad32.exe" -- without quotes into the dialog. Then create the connection to the database as you
would on a 32 bit machine.

Source: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=8&cad=rja&uact=8&ved=0ahUKEwiZ2aaEzoXVAhWJHxoKHarHDesQFghaMAc&url=http%3A%2F%2Fwww.weberpackaging.com%2Fpdfs%2FHow%2520to%2520get%252032_bit%2520ODBC%2520Drivers%2520on%2520Win7_64bit%2520PC.pdf&usg=AFQjCNHdvu2wx7k1uFdTru-xpgSsksmjew

SQL - Improve Query Performance

Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.

USE db_reports;
GO
UPDATE STATISTICS tb_applicationusage;
GO

VMWARE-FREE: failed to lock the file cannot open the disk

The Error is:

Failed to lock the file
Cannot open the disk '/media/remy/WD My Book/Laptop-Remy/Laptop-Remy.vmdk' or one of the snapshot disks it depends on.
Module DiskEarly power on failed.
Failed to start the virtual machine.

The Solution is:

Need to verify that there are no .lck files or folders in the VM's directory.

Clone an SQL Server database on the same server in SQL Server 2008 Express

Install Microsoft SQL Management Studio, you can download it for free from Microsoft website: Version 2008 Microsoft SQL Management Studio 2008 is part of SQL Server 2008 Express with Advanced Services Version 2012 Click download button and check ENU\x64\SQLManagementStudio_x64_ENU.exe Version 2014 Click download button and check MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe Open Microsoft SQL Management Studio Backup original database to file (db -> Task -> Backup). Create empty database with new name (clone). Click to clone database and open restore dialog (see image) Select Device and add the bakcup file from step 1. 4.Change destination to test database Change location of database files, it must be different from the original. You can type directly into text box, just add postfix. 6.Check WITH REPLACE and WITH KEEP_REPLICATION   Source : http://stackoverflow.com/questions/3829271/how-can-i-clone-an-sql-server-database-on-the-same-server-in-sql-server-2008-exp

Microsoft ACE OLEDB 12.0 connection strings

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97

↯ Problems connecting?

Get answer in the Excel 97 Q & A forum

Excel 2000

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97
• 
  

Excel 2002

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97

Excel 2003

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97

Excel 2007

• Xlsx files

  Connect to Excel 2007 (and later) files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Treating data as text

  Use this one when you want to treat all data in the file as text, overriding Excels column type "General" to guess what type of data is in the column.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
  If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
  To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider the scenario that one Excel file might work fine cause that file's data causes the driver to guess one data type while another file, containing other data, causes the driver to guess another data type. This can cause your app to crash.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsb files

  Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.
  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;
Extended Properties="Excel 12.0;HDR=YES";
  You can also use this connection string to connect to older 97-2003 Excel workbooks.
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsm files

  Connect to Excel 2007 (and later) files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

Excel 2010

• Xlsx files

  Connect to Excel 2007 (and later) files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Treating data as text

  Use this one when you want to treat all data in the file as text, overriding Excels column type "General" to guess what type of data is in the column.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
  If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
  To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider the scenario that one Excel file might work fine cause that file's data causes the driver to guess one data type while another file, containing other data, causes the driver to guess another data type. This can cause your app to crash.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsb files

  Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.
  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;
Extended Properties="Excel 12.0;HDR=YES";
  You can also use this connection string to connect to older 97-2003 Excel workbooks.
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsm files

  Connect to Excel 2007 (and later) files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

Excel 2013

• Xlsx files

  Connect to Excel 2007 (and later) files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Treating data as text

  Use this one when you want to treat all data in the file as text, overriding Excels column type "General" to guess what type of data is in the column.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
  If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
  To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider the scenario that one Excel file might work fine cause that file's data causes the driver to guess one data type while another file, containing other data, causes the driver to guess another data type. This can cause your app to crash.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsb files

  Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.
  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;
Extended Properties="Excel 12.0;HDR=YES";
  You can also use this connection string to connect to older 97-2003 Excel workbooks.
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsm files

  Connect to Excel 2007 (and later) files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

Access 97

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2000

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2002

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2003

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2007

• Standard security

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• With database password

  This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
  Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

  • Access 2007
  • Access 2010
  • Access 2013

• DataDirectory functionality

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• Network Location

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;
  • Access 2007
  • Access 2010
  • Access 2013

Access 2010

• Standard security

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• With database password

  This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
  Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

  • Access 2007
  • Access 2010
  • Access 2013

• DataDirectory functionality

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• Network Location

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;
  • Access 2007
  • Access 2010
  • Access 2013

Access 2013

• Standard security

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• With database password

  This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
  Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

  • Access 2007
  • Access 2010
  • Access 2013

• DataDirectory functionality

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• Network Location

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;
•  

Source: https://www.connectionstrings.com/ace-oledb-12-0/