Odd error message

  • Thread starter Thread starter Marc
  • Start date Start date
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
 
You probably have warnings set off. Try press Ctrl+G and then enter
DoCmd.SetWarnings True
 
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
 
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?
 
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
 
Back
Top