Sorry, I am assuming that this is answered somewhere on here (or in Internetland) already, but I cannot seem to find the answer to my problem (and I am not sure if this belongs under .ASP or ...).
Access file (database) and site hosted on local (business) server
Copy of the same Access file (and site with alterations) hosted on external server
How can I updated both at the same time
I realize I can just copy my .mdb file to from localsite to hostedsite, but the upload tends to take about 120 seconds, and the downtime is unacceptable.
All I want is to update both files at the same time, or mirror them. Basically I could get this complete to my satisfaction (non-mirrored) if I knew how to use DATA SOURCE="http://somewebsite.com/folder/file.mdb", but I cannot seem to make that work ...
I was looking to find out how to change RDS (MS Remote) settings. I have a website that is hosted locally that I want to update (the Access file) on the network simultaneously, and this is the only way that I am seeing to do this. When I attempted to do so, I received:
Microsoft ADO/RDS error '80072f78'
Internet Client Error: Invalid Server Response.
As this is a new concept to me, perhaps I have something miscoded on my end, but I do not want to bang my head against the wall if this is something that is not supported. Please advise.