I have a live website which uses an MS Access database to hold data and uses ASP to interrogate it.
Several tables in the database relate to stock items and cross-referencing to them.
Several other tables relate to user orders.
I want to be able to update the stock item and cross-reference tables on the site whilst keeping the site live and leaving the database accessible. What is the best way of doing this?
At the moment, I do this very awkwardly by downloading a copy of the site database from the site to my PC ( with the latest set of order information in it ), overwriting the relevant product tables, then quickly uploading it back to the site before someone else places an order on it. If someone attempts to place an order while I am doing this, there is the risk that my upload of the database will overwrite the order, leaving no record.