Odd error message

M

Marc

Hello,

I have a make table query that is the last in a string of
several queries, which it uses to create the table. When
trying to run it a second time I get the message "Table
TABLENAME already exists." It doesn't ask if I want to
delete the current table, or anything like that. The error
message does not allow me to continue.

Can you help?

Thanks,

Marc
 
D

Duane Hookom

You probably have warnings set off. Try press Ctrl+G and then enter
DoCmd.SetWarnings True
 
G

Guest

Hi Duane,

Thanks, but I checked that and that's not it. I get the
first warning "You are about to run a make table
query....". Any other ideas?

Thanks,

Marc
 
D

Duane Hookom

Do you have the table open? Are you the only user in the mdb? Can you do
this with other mdbs and/or other tables?
 
M

Marc

Hi Duane,

The table is not open. Yes, I'm the only user in the
database. This is the only make-table query in this
database, but I've never run into this problem in other
databases. I just created another make-table test query in
this same database and did not have the same problem.
Perplexing!??

Thanks,

Marc
 
Top