![]() ![]() If the second (x86) file exists then you know that the 32-bit version of the Access Database Engine is present on a 64-bit machine. On a 32-bit machine it indicates that the 32-bit version is installed. On a 64-bit machine the first file indicates that the 64-bit version of the Access Database Engine is installed. If you have access to the web server, you can check for the existence of the following two files: C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLLĬ:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL Set rst = CreateObject("ADODB.Recordset") The Microsoft Access 2013 Runtime enables you to distribute Access 2013 applications to users who do not have the full version of Access 2013 installed on their computers. Set con = CreateObject("ADODB.Connection")Ĭon.Open "Provider=.12.0 Data Source=C:\Users\Gord\Desktop\Database1.accdb Persist Security Info=False " Note that the 64-bit installer includes the 64-bit version only it does not include the 32-bit version (available separately on that same page).Īs for the connection string, I just tested the following VBScript on my Access_2013 machine and it worked fine. ![]() If that machine does not have Access installed on it then you can download the installer for the engine here. The machine acting as the web server must have the "Microsoft Access Database Engine 2010" installed. ![]()
0 Comments
Leave a Reply. |