Problem linking with SQL Server
 

Let me just apologise, I didn't notice that this was in
fact the Excel group and totally unrelated to my
question :)



-----Original Message-----
I have an MS Access based front end to an SQL Server
database. If I create records using the Access client all
works fine, however, I have an old MS Access DB that I'm
trying to take records from.

I've tried doing it numerous ways, but the only way that
seems to work is by using an INSERT..SELECT statement
within the old Access DB that adds the records. However,
if I then use Access to edit a record it then pops up an
error box saying that the record may have been changed
and
my changes cannot be saved.

I assume this is something to do with the way records are
timestamped to warn against consistency problems.

Anyway, I can't figure out how to sort this. I need to
add
old records, but every method I've tried means I can't
edit them afterwards. I'm using SQL Server 2000 and
Microsoft Access 2000 with MDAC 2.7 SP1.

Any suggestions would be appreciated.

Regards,
Paul

.