We have setup an online shop for a client and are using a SQL server database for all their stock, etc. They receive a monthly stock update from there main supplier which is stored in an access db on their pc's at their bricks and mortar shop.
I am looking to the most efficient way of updating the SQL database (on a shared hosting server) from the Access db on the clients PC.
At present, the client uploads the access mdb file to a location on the server which we have set up as a DSN and I run some Coldfusion code to extract the data, query it and then update the SQL database. This worked on our dev server but is timing out on the shared server (process takes around 1-2 hours).
I think this is probably a most ineficcient way to do things, can anyone point me to a better method?
Thanks in advance
DT
I am looking to the most efficient way of updating the SQL database (on a shared hosting server) from the Access db on the clients PC.
At present, the client uploads the access mdb file to a location on the server which we have set up as a DSN and I run some Coldfusion code to extract the data, query it and then update the SQL database. This worked on our dev server but is timing out on the shared server (process takes around 1-2 hours).
I think this is probably a most ineficcient way to do things, can anyone point me to a better method?
Thanks in advance
DT