Guest Posted December 31, 2003 Share Posted December 31, 2003 I am connecting to the mysql database using ODBC so I can change data quickly via MS Access. I am looking at a quick way to quickly delete old products. I currently import the list of my current active products using easy populate. In Access I can sort the products table by the products_last_modifed field. This shows me all the products that were not updated in my last import. My first question is, if I delete these old products via Access will it break other parts of the database (i.e. products to category etc) or will they behave without deleting the reference to the old products. My second question is, will deleting old products break any part of the customer and/or order records if there are purchases for the product being deleted? Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2003 Share Posted December 31, 2003 I have a similar issue and look forward to a response on this. Thanks Link to comment Share on other sites More sharing options...
Guest Posted January 2, 2004 Share Posted January 2, 2004 I looked at the tables, in orders_products, there are quite a few fields there associated with the products. The orders_id shows the order number, products_model, name, price and final price, tax, etc, are all tied in with the products. From what I can tel, if you delete this, then the customers or you will no longer have access to specific detail to the orders, however you will have a general overall of the orders. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.