ADP "Connection Failure" when saving record

[denton]

I am running a MS Access 03 and 07 (different computers) Access data Project
connecting to a Local Server database on SQL Server 2005 and I get this error
message whenever I try to insert a new record in a table OR modify a record:
"Connection Failure".

The message also pops up when i open certain tables. The ADP worked fine on
an older computer I moved from. I cannot find ANY references to this error
on the WWW!

 

[Sylvain Lafontaine]

Make sure that each user/machine has their own copy of the ADP file and take
the precaution of decompiling it twice before using it on a new machine.
Also, check the references.

 

[denton]

I think something in my DB got corrupted in the process of copying it around
this message shows up in my App event log:
Possible index corruption detected. Run DBCC CHECKDB.

Maybe this is the problem. Do you think I should try deleting all the
indexes in my DB? Now I see almost nothing on this error on the WWW.

 

[Sylvain Lafontaine]

Quite possible but this message if for the sql-server database, not the ADP
project. Run DBCC CHECKDDB on the sql-server to see if this correct the
situation. If not, make a backup/restore or recreate a new database and
copy all the data into it.