>Cool. Never thought of that and was instead keeping templates of original tables with indexes and no data in them (metadata - I'd keep anyway as a data dictionary).

Yes, this is a really cool approach. I have a Tag.dbf part of the administration tables. I read that, built the commands and pass them up to the ExecuteNonQuery() method of the data provider class. Before that, I issue an application lock and unlock it after.