Creating a table with a CrossTab Query

  • Thread starter Thread starter GOU
  • Start date Start date
G

GOU

Hi,

I have a "Create Table Query" who use a "CrossTab Query"
for is source.

When I execute the "Create Table Query" for the first
time, the table is create with no problem. If I try it
again, I have an error message telling me that "the Table
<name> already exists (Error 3010)".

Should I do something special with my "CrossTab Query" so
I can use it in my "Create Table Query" ?

In VBA some told me to use a "DROP Table" before using
the "Create Table Query"...

Thanks.
 
You could do something like:

If isobject(actable, "TableName) then
docmd.deleteobject actable, "TableName
endif

Then run the query after the table is deleted.

DROP is a SQL command, and could be used as well.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top