M
Mark
I have a query that pulls about 1/2 million records that I
want to dump as a reference table. I can write a query to
create a table and that works fine, but when I try to
modify it to an append query, I get a message Record
Deleted when the query runs, and no records are appended.
Now I know I could run the Make Table and then append the
results, but with that takes twice as long, and causes
bloating in my front end that I would rather avoid.
Is it possible to write VB code that makes a table into
another database?
Thanks
Mark
want to dump as a reference table. I can write a query to
create a table and that works fine, but when I try to
modify it to an append query, I get a message Record
Deleted when the query runs, and no records are appended.
Now I know I could run the Make Table and then append the
results, but with that takes twice as long, and causes
bloating in my front end that I would rather avoid.
Is it possible to write VB code that makes a table into
another database?
Thanks
Mark