Re: Suggestions for MS Access Web-based Replacement.
BTW, none of the "Data Access Pages" included with MS Access will work for more than one computer unless you set up a "three tiered server" system. It's definitely NOT worth the effort to even research this crazy method.
And I use MS Access every day and I don't think there's any tool that "exports to asp" other the data acess pages which, again will only work on an expensive three tiered server system.
If you do find a way to make them work over the internet let us know the world wants this.
Dude did say "web based" not "LAN based" so mounting drives etc. won't do either, unless everyone who needs it is on the same network and there is a MS Server in the house as well. Then it may be a good idea to consider a local access only application.
There's no way around development when your trying to make a web application.
" . . . you can always move the tables and data to any odbc complaint database (like kguns suggestion for MySQL) and then just link the tables through your master access database. . ." This will just make your performance problems worse.
Please don't think you can just migrate data from one any odbc compliant database to another. There ARE compatibility issued (not all databases have the same datatypes).
It sounds as though RichAtVNS is using a dedicated MS web server (you can't even view what drives are attached to a machine when using a shared hosting account, much less mount a new one), and a big fat one at that. This probably isn't an option for most because of the enterprise level costs involved.
RichAtVNS: Why even do the mounted drive thing?
|