Database guidance
Could you reply with the best way to clean up the database, within the confines of not wanting to reenter any data. You also mentioned cleaning up the tables, besides looking for any quotes, what are you referring to in the clean up process?
I agree on a new database, but are you suggesting making a fresh database with all new tables with no data in them? If so I have two concerns.
(1) I have over 3,600 options entered and 170 products in this database, so the idea of rekeying this is pretty much out of the question unless absolutely necessary.
(2) If I dump just the data from the existing tables and import the data into the new database with new tables, won't that just carry over any errors that might exist in the current database?
Any help on the steps I might take to make the database more reliable would be appreciated. Oh, one more thing, this powerstore was up dated from version 2 to version 3, so all the old tables still exist in the current database along with the new table structure, this has always bothered me, not knowing which old tables could be removed from the database.