We require an MSAccess db with an FTP com installed. This is a very small database that will automate updating both a website and external accounting database.
When client enters products into info Access, he will select product image from local directory. It will be ftp'd to website and url will be save with other product info. Info will be stored in MySQL web db & Accting DB at same time thru ODBC.
accounting db 1 table 42 fields (only 9 will be updated)
web db 15 tables 8 fields each is a category of product.
There are many ftp coms online. We will pay for it if necessary.