>I need to clean out records from my tables that are old but keep them around in case we need them again. What is the best approach for archiving records. In my main form for my app the dataenvirnment loads all the tables so cleaning them out might help my app to load a little faster. Note some of the records have memos and general fields I need to archive.
It seems to me that this isn't required, most of the time. Data access can be quite fast, even for bigger tables; and data access can be much more complicated if you want to access archived records.
You do have to worry about the limitation of 2 GB per table, of course.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)