Odd error message

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


--
Duane Hookom
MS Access MVP
--

"Marc" wrote in message
...
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

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

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


--
Duane Hookom
MS Access MVP
--

"Marc" wrote in
message
...
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


.

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?

--
Duane Hookom
MS Access MVP


wrote in message
...
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

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


--
Duane Hookom
MS Access MVP
--

"Marc" wrote in
message
...
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


.

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

-----Original Message-----
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?

--
Duane Hookom
MS Access MVP


wrote in message
...
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

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


--
Duane Hookom
MS Access MVP
--

"Marc" wrote in
message
...
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


.



.