Greetings...
Is there another way (script or..?) to compact database in Microsoft Access beside using Tools-->Database Utilities-->Compact and Repair Database..? I had a main macro which contains: - Query1: Import text data to TableData_temporary - Query2: Do select query and process some field from table TableData_temp and put the result into TableData_permanent - Query3 or child macro to run automate compact (is this possible? Since I don't need TableData_temporary anymore I need to delete all the records from it and automatically compacted to avoid large filesize) - Query4: Do data processing for TableData_permanent I really need this automate compact because the data was so huge. I have had experience that my Access stopped its process with 2GigaByte data. Please kindly help me. Thanks & Regards, Dior [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
