temporary recordsets, tables

[MBall2003]

I have created a temporary table to manipulate some date now after i manipulate the data i want to delete all the records from that table how can i do that any help would be appreciated thanks

 

[jebry]

Hi!

Try:

Delete * From YourTable

hth


Jeff Bridgham
bridgham@purdue.edu

 

[mpastore]

Numbr of ways to do it.

- from the database window you could just open the table, select all the records (click upper left gray box on the browse grid) and press the delete key.

- within code you could do something like:

currentdb.execute("delete * from mytable&quot

You might want to compact the database afterwards in otder to regain disk space and make other tasks more speedy.

Mike Pastore

Hats off to (Roy) Harper

 

[JeremyNYC]

If you're going to be doing this on a regular basis, I'd use a temporary database that gets replaced each time, so that you don't have to cycle through the compact process so many times. On the other hand, if you describe the process you're working on, I would bet that we can give you suggestions for a better way to go about it. In eight years of Access programming I've never done anything other than a temporary solution that used temporary records or temporary tables.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[JeremyNYC]

Oh, wait...I lied...one very big process. I don't like it a bit, and I'd love to come up with an alternate solution, but I haven't...yet.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.