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!

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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"denton" <(E-Mail Removed)> wrote in message
news:6C9229CC-FF64-4548-B0E8-(E-Mail Removed)...
>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!

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" wrote:

> 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.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "denton" <(E-Mail Removed)> wrote in message
> news:6C9229CC-FF64-4548-B0E8-(E-Mail Removed)...
> >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!
>
>
>

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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"denton" <(E-Mail Removed)> wrote in message
news:EFDE483A-6D07-46C4-B3E2-(E-Mail Removed)...
>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" wrote:
>
>> 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.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>
>>
>> "denton" <(E-Mail Removed)> wrote in message
>> news:6C9229CC-FF64-4548-B0E8-(E-Mail Removed)...
>> >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!
>>
>>
>>