Make Table Field Size Issue

[pgh2377]

I have a Macro I use to produce a daily report. Each day the first query which is a make table deletes the previous day's results. However, the one field I pull in has characters longer than field size of 10. So everyday when the make table deletes and remakes the table the field size properties are set back to 10. Can anyone suggest what I could do do keep the field size large so that it doesn't cut of information (i.e. my program names)

Thanks

 

[BobJacksonNCI]

Instead of delete table + make table, I'd delete the contents of the table and then append data. That allows your structure to remain intact. Further, you could add indexes, if appropriate. They would be maintained automatically and speed up access, although the previously run append could then take a bit longer.



HTH,
Bob

 

[willir]

How much data are you talking about?

For a few records, say less than 100, use the delete record method decribed by Bob. A lot less trouble.

But if you have a large number of records, the delete table / make table is much faster. (I have the code buried some where in an older database if you want me to dig it up.)

Richard

 

[BobJacksonNCI]

Just had a cup of coffee ... and realized I didn't mention something. Make-table creates field sizes based on the first row of data. If you stick a dummy row in at the beginning and then delete it after table creation, your problem is solved.

Still, I prefer delete/append records because my database size doesn't fluctuate much and requires less compaction to remain efficient.



HTH,
Bob