Invalid Argument when running a Make Table Query

[Sambro]

Hi,
I am working in a database and I made a make table query to make a smaller
version of a large table. The first time I created the table, it ran fine.
Later, I changed the criteria of the make table query. This would cause more
records to be produced in the table to be created, but it should not have
altered any of the fields. When I attempted to run the query, it first
deleted the old table, then I received the error Invalid Argument. Now, if I
try to run any make table query, I receive the Invalid Argument error (after
it deletes the old table if there is one), and the query does not run.
Please help.

 

[Jeff Boyce]

Sambro

I haven't seen that behavior before, have you tried searching on-line?

Have you tried making a copy of your Access database, then running compact &
repair on it?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Sambro]

This error is coming up in the copied database. In the original database, I
changed the name of a table that was created by a make table query.
Afterward I tried to rerun the query, and I received the Invalid Argument
Error message. I have tried Compact and Repair, but the error still remains.
I cannot run any make table queries.

 

[Jeff Boyce]

Sambro

I'll mention that a more common approach is to avoid using Make Table
queries altogether.

If you create a table that will hold the data you've been using make table
to create, then you can use an append query to add new records and a delete
query to empty it out. That way, you get to control the data types of the
fields, etc.

Regards

Jeff Boyce
Microsoft Office/Access MVP