HungryMind 0 Posted May 2, 2011 Report Share Posted May 2, 2011 Hi!I've two web hosting.My Ms Access Database is placed on e.g: host1My Other site is placed on e.g: host2I want to use my Ms Access Database on host 2 from host1.Is it possible?Please guide. Quote Link to post Share on other sites
Skemcin 13 Posted May 2, 2011 Report Share Posted May 2, 2011 It's possible, but in a hosting environment that you don't control, the technical requirements to make it possible are not likely going to be permitted.Having said that, one question I would ask is if the second site needs the database from the first site in real time? If not, how often would it need to be updated. The solution here would be to FTP the database from Site A to Site B on a regular schedule - of course, you would code your site to make sure all database connectivity was disabled during that time. This is not pretty, but its an option.Alternately, you could build a series of web services that synchronizes your data between the the two sites. Again, you can do this in real time or have it a scheduled task. Without know how much traffic and data we're talking about, I couldn't tell you whether this route is feasible either - but its a step up (at the very least) from the first solution.Does that help?By the way, unless there is an offline need/use for the data to be stored in MS Access, you should really migrate the data to something more appropriate for web use - like MS SQL or MySQL. Quote Link to post Share on other sites
justsomeguy 1,135 Posted May 2, 2011 Report Share Posted May 2, 2011 http://www.google.com/search?client=opera&...channel=suggest Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.