Access 95 Linked Tables with SQL Server 2000

[Darren Brinksneader]

Hello,

I have a customer with an Access 95 database with linked
tables to SQL Server 2000. I am running on Windows XP
with the latest MDAC applied.

The table were copied using DTS into SQL Server. Linked
tables are functioning as expected for Inserts and
Updates. When I attempt to deleted a row from a linked
table I get the following error:

"Data has changed; Operation has stopped"

Unless all fields in the row are populated, with the
exception of the "Memo" (SQL Text) data type, I cannot
delete a row.

It does the same thing with the Pubs and Northwind
databases. I know it is an issue with Access 95, or at
least an issue with the SQL Server driver version.

Anyone seen this....Help!!

Thanks

P.S. I cannot convert the front-end Access database until
they fix some problems with their VBA code.

 

[Joe Fallon]

A95 was one of the unstable versions.
Everyone moved to A97 right away. It was the best version for many years!
A2002 and 2003 are very good.
Access had the reputation of every other version being buggy.

Anyway - I would upgrade.

Oh - not an option yet? Darn.

Make sure the tables have PKs.
Try (in Test lab) adding a timestamp field to a table and re-linking it.
Then try a Delete.
Access will not do a field by field comparison if a timestamp exists.

 

[Darren Brinksneader]

The timestamp did it. Thanks!!!!!!

-----Original Message-----
A95 was one of the unstable versions.
Everyone moved to A97 right away. It was the best version for many years!
A2002 and 2003 are very good.
Access had the reputation of every other version being buggy.

Anyway - I would upgrade.

Oh - not an option yet? Darn.

Make sure the tables have PKs.
Try (in Test lab) adding a timestamp field to a table and re-linking it.
Then try a Delete.
Access will not do a field by field comparison if a timestamp exists.

--
Joe Fallon
Access MVP



"Darren Brinksneader"


.

 

[Joe Fallon]

"Even a blind squirrel finds an acorn every now and again."

Glad to hear it.