Microsoft Access (Office 365) connection string

[Trevor Hughes]

Hello

We have recently upgraded to Office 365 and since this change I have been unable to query my Access database and I receive the following error message:
Line 8 - No valid connection

The connection string I have been using successfully prior to the change is:
DBConnect>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\CusMod Testing\JBMS Testing.accdb;Persist Security Info=False,PAXTesting

Could someone help with an updated connection string that will work with MS Access 365.

I appreciate any help that can be provided.

[Jiyahana]

Please try to replace this

Code: Select all

Provider=Microsoft.ACE.OLEDB.16.0;Data Source=c:\CusMod Testing\JBMS Testing.accdb;Persist Security Info=False;

into your db connection string and then try on the other hand you can go through the official documentation.