I had working VBA code in Access 97 that opened a Recordset object using records from a query that drew fields from two related/referential integrity linked one-to-one tables via indexed AutoNumber field (in the primary table). I could then use the "recOBJECT.AddNew" method that would happily add a record to each of the underlying tables.
I "updated" to Acess 2000. Now my code is broken. The AddNew method still works but the second I try to put data in the new record, Access crashes with the "creating log file" idiot message (where IS this mythical log file anyway...) It doesn't work to add a record directly to the Query Dataview screen either, but I CAN add individual records to.each table. Why did my referential integrity go away and how can I get it back? Any help out there? (Thanks in advance)!