CODEWITHSUNDEEP
sql-server-2008-r2ms-access-2010windows-7-x64
Steven Ball
Steven Ball

Reputation: 481

MS Access ADP Connection Error

I inherited a Microsoft Access 2000 ADP project a while back. For a long time it ran successfully on Windows XP, but we recently began upgrading to Windows 7 workstations. I was able to get the ADE file produced from building the ADP project working, however I cannot seem to open the ADP file without error.

The error message I am getting is below. The ADP project uses SQL Server 2008 R2 for the back end and I am using Access 2010 to open it on my Windows 7 (64 bit) workstation.

enter image description here

My connection string is below (with values substituted for the actual server and database):

PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=database;DATA SOURCE=server

Any assistance in debugging this error is greatly appreciated.

Upvotes: 1

Views: 671

Answers (1)

Steven Ball
Steven Ball

Reputation: 481

I think it was just a bad ADP file. I downloaded the same code from a different location and it worked.

Upvotes: 1

Related Questions