Devam Ediyor

Database Clean up Help

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.

Beceriler: SQL

Daha fazlasını görün: my sql create database, ms project help, data clean-up, clean-up, clean up, access clean data, run access function sql, delete function, access 2007 2010, create access project database 2010, sql database front end, clean access project, clean database access, access database clean, clean data access table, access projects sql server, clean table access, access project database, front end sql database, access 2010 help, front end end access 2010, create end access 2010 database, 2007 front end sql server, front end access database, database sku

İşveren Hakkında:
( 22 değerlendirme ) Wilmington, United States

Proje NO: #6536092

Seçilen:

gkalish

Hired by the Employer

4 gün içinde 50$ USD
(101 Değerlendirme)
5.6