Andy Lacey
andy at minstersystems.co.uk
Fri May 21 04:39:42 CDT 2004
I know it's not what the message says, but it couldn't be breaking RI rules could it? i.e. no parent record. If you open the linked MDB can you insert the same record direct? -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: Access Developers discussion and problem solving <accessd at databaseadvisors.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Subject: [AccessD] Odd Error Date: 21/05/04 07:53 > > 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 > > > > > ________________________________________________ Message sent using UebiMiau 2.7.2