My front end used to communicate with the SQL server is a MS Access project. projects are no longer supported in newer versions of Access (dropped in 2010). It still works well, but I have to run accesss 2007 to use it.
Our item delete function is not working properly. Whenever we delete an item through access, it only removes the item from the item table, leaving the related table still populated with the item.
When we create on new item, information is entered into mnm21_item; mnm_item_inventory; mnm21_item_attrib; mnm21_item_text.
But when we use delete record in Access, it only removes the sku from mnm21_item table, not from the other 3.
This does not stop the site from working properly, but is just a database clean up thing. the other 3 tables are becoming large with irrelevant sku data.
just wondering if you have any idea on this.