1

Currently there is a Excel 2002 spreadsheet writing/retrieving data from a Access 2002 database. IT is presently researching a upgrade to Office 2007 and when I upgrade both the spreadsheet and database the ADODB connection fails.

The 2002 era VBA connection string is:

Provider=Microsoft.Jet.OLEDB.4.0;
Jet OLEDB:Database Password = stackoverflow; 
Data Source= \\test\test.mdb"

In usage:

Dim cnt As ADODB.Connection
Set cnt = New ADODB.Connection
cnt.Open LiveCon

Changing the .mdb suffix to .accdb breaks the connection. Can someone direct me to the new syntax for the connection string?

Improve this question

2 Answers 2

Reset to default
2

You may find this helpful: http://www.connectionstrings.com/access-2007

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks - keep forgetting about that website.
1

Try changing 

Provider=Microsoft.Jet.OLEDB.4.0

to

Provider=Microsoft.ACE.OLEDB.12.0
Improve this answer

1 Comment

After I upgraded the provider string a 'Could not find installable ISAM' error messsage appeared. After some research it appears that the '2007 Office System Driver: Data Connectivity Components' may need to be installed. The library can be found at: microsoft.com/downloads/…

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.