Deleting a table

[alien2_51]

I have an access database that I've DTS the results of several financial
reports into. There was an error in one of the DTS packages and I had to
re-run it. Rather than deleting the data in the table I deleted the table.
When I got back into the DTS designer and tried creating the new table I got
an error Invalid Argument. I noticed that after deleting the table the file
size for the mdb did not change. Does this mean that the table is still
there...? How do I get rid of it, for good...TIA

Dan

 

[Arvin Meyer]

Run a compact and repair. The table has been deleted, but the data is still
there. Compacting will clear it out.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[alien2_51]

Thank you..

Run a compact and repair. The table has been deleted, but the data is still
there. Compacting will clear it out.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:[email protected]...