Is it possible to connect to an Access database on another server?
Yes. This setup requires 2 basic steps. 1) the server running ColdFusion will need a mapped network drive to the remote Access DB file. 2) ColdFusion will need to be running under a user account that has access to the Access database on the remote server. By default, ColdFusion runs under the System account which would not have rights to access the database file on the remote server.
This question was written by Jeremy Petersen.
It was last updated on June 19, 2007 at 8:53:20 AM EDT.
Categories
Comments
Comment made by TJ Downes on June 19, 2007 at 11:09 AM
One might add that this is not recommended. First and foremost, the performance would be terrible. Secondly, Access in general is not a recommended web app. Access-based applications can easily be ported to MS SQL using a wizard in Access (the upsize wizard) which allows you to keep the Access interface. If you're not using an Access application then just migrate to MySQL, it is free.
Comment made by Raymond Camden on June 19, 2007 at 11:16 AM
While Access is definitely not recommended, the truth is that many people still use it, and will continue to use it.
Comment made by Joshua Curtiss on June 20, 2007 at 11:31 AM
In some cases, too, the database might already have an Access front end in VB, and porting the database to MySQL or MSSQL may cause an undue amount of work on the Access front end. Especially if the web end would be read-only and not an extremely high traffic page.
Comment made by Michael Sammut on June 26, 2007 at 9:52 AM
Joshua is right on. This person has been developing a VB front end for over 4 years and the conversion would be a nightmare. The web end is read only. Thanks for all the insight.