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: sql create database, clean up, access clean data, run access function sql, delete function, access 2007 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 access database, database sku, database related works, data clean project, clean access 2010 database, access sku database, delete record, sku access database, data clean access

İş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