Microsoft Access (Office 365) connection string

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
Trevor Hughes
Junior Coder
Posts: 25
Joined: Sun Dec 15, 2013 9:27 pm

Microsoft Access (Office 365) connection string

Post by Trevor Hughes » Mon Feb 12, 2024 10:29 pm

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
Newbie
Posts: 10
Joined: Thu Jan 18, 2024 10:03 am
Location: India
Contact:

Re: Microsoft Access (Office 365) connection string

Post by Jiyahana » Tue Feb 13, 2024 8:49 am

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.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts