Access 2000 Project not connected to SQL server

C

ChelleV

We have one user who belongs to the same role as the rest
of the group, everyone is on W2K, has Access 2000, etc.
He can open the .adp file, but cannot see any of the
tables or open any report, form. he keeps getting this
message: ACCESS WAS NOT ABLE TO PERFORM THIS OPERATION
BECAUSE THE PROJECT IS NOT CONNECTED TO A SQL SERVER
DATABASE.

When it initially opens to the home screen, if you go to
File/Connection, it lists the correct server and database,
and TestConnection says it is connected.

Any other ideas?

Thanks,
ChelleV
 
C

ChelleV

Actually, I found the fix myself, but wanted to post it in
case anyone else came across this. This person had recent
re-built his machine. He was missing a component of
Access. If you go to this link, it is the #7 download.

http://www.microsoft.com/downloads/results.aspx?
productID=327F343D-F0D6-4E07-AA53-
9656EDB98ADA&freetext=&DisplayLang=en
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 can't connect to SQL Server 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Log-in when Project Starts 1
Access 2007, SQL 2000 3
Adodb connection to different SQL SERVER DB 3
Opening 2003 ADP in 2007 fails even with newly defined SQL Serverconnection 12
Access 2000 & SQL Server 2005 3
What's the steps to modify a .adp connect string & convert DAO to 2

Top