Recent content by Daadian

LOL compact and repair fixed it right up. Okay another question is there an easier, or more efficient way, to handle all of these queries or is this just fine to do things this way ?

Compact and Reapir fixed my slowness problem. Phew ! Any suggestions on avoiding using 20+ update queries or is that really a problem ?

EVERYTHING slows down, opening very simple forms is slow, loading drop down box values pulled from a table is slow. Opening the main table itself is slow. And no its a single database, with for all intensive purposes a single table holding all of the data.

Okay my database is going to be very large, monthly totaling about 600,000 records. (I plan to keep seperate databases every month just for size and speed purposes). Currently the databases imports a text file daily into a table. Using VBA, after the import is done, approx 20 update queries are...

Okay I have searched and searched for this and there HAS to be an easy answer. I have a macro that imports a delimited text file, appending data in an existing table. The table has a field that I added, for "As of Date". That remains empty and basically ignored during the import process which is...