I am trying to append data from an Oracle table to an Access table and I’m getting an error - “Run time error 3167 - Record is Deleted”.
The Access table I’m appending to is in a separate backend .accdb file / the front end is also .accdb format
The query joins multiple Oracle tables with a complex selection criteria
This query was working – I ran it multiple times while I was refining the selection criteria over the last two weeks – I’ve only started getting the error in the last few days - and yes multiple things have changed, the database is a work in progress
Here are the things I’ve tried:
I can run the query in select mode and it displays all the records correctly
I can run the query as a make table query and it creates the table correctly
I was able to identify the specific records it was failing on, then exclude that record and the query will append a few more records – but with over 3000 records I never excluded all the failing records.
I’ve switched from our Oracle test environment to our production environment
There is nothing different about the records it’s failing on – they have not been ‘deleted’
I can use code with a recordset to read the data from the select query and append it to the access table – but it’s very slooooow!
I’ve done multiple compacts of both back & front end files
Since this query was working previously it’s got to be something stupid that changed but I’m stumped
does anyone have any sugestions??