[AccessD] Odd Error

That suggests either an RI issue or something awry in the way you're
doing the insert.  Or a permissions issue on the linked datafile.  Do
you have security on the linked file? 

Charlotte Foust

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Thursday, May 20, 2004 11:51 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Odd Error


I am doing an Insert to a linked table and it continually fails with the
error. The linked table is in another Access db.

Record is deleted.

When I run the select it returns the records ok only fails on the
INSERT. Even if the INSERT is only trying to add two records it fails.

I checked the web etc and found referencees to an old bug in Access 2
whcih was related to this but dont think it applies in this case. Anyone
any ideas?


Martin



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com