maintaining products

Comersus Version: 600
Database type: Access
Frequency: Permanent issue


Hello: we have over 2000 products entered into our PRODUCTS table. The prices change as do descriptions. Often times products are no longer available and must be removed. I would like to maintain our products outside of the application using Access queries that match on the SKU. I would update the description and price. i would also link to another table in another DB and delete products from the PRODUCTS table that are no longer available. I would also want to insert into the PRODUCTS table outside of your application. Is this going to cause us a problem? Can you see any issues with maintaining the PRODUCTS table using adhoc queries and doing so outside of the add/modify/delete functions of your application?

3 Comments

Add a Comment

Your email address will not be published. Required fields are marked *