M
Mark
I am building a reference table that I am creating to
eliminate re-querying several tables numerous times. I've
written the SQL and am using the docmd.runsql command to
execute the query.
My problem is that when I execute the SQL in a make table
version the code works fine, but when I try to use an
append query version, I get a message that says Record
Deleted, and then it doesn't append any data.
I can get by with creating a temporary table and then
appending the records to my reference table, but that
seems redundant, and is rather time consuming when we're
talking a half million records.
Any thoughts on what could be the problem? Doesn't Access
97 take a snapshot of the data for both make and append
queries?
Mark
eliminate re-querying several tables numerous times. I've
written the SQL and am using the docmd.runsql command to
execute the query.
My problem is that when I execute the SQL in a make table
version the code works fine, but when I try to use an
append query version, I get a message that says Record
Deleted, and then it doesn't append any data.
I can get by with creating a temporary table and then
appending the records to my reference table, but that
seems redundant, and is rather time consuming when we're
talking a half million records.
Any thoughts on what could be the problem? Doesn't Access
97 take a snapshot of the data for both make and append
queries?
Mark