Webpage connection to Access

[cmarsh]

What is the easiest and best way to make a database accessible thru web
pages? I have started with Data Access Pages and find that everything needs
to be changed around(coding, controls etc.). Have read many posts and forums
discussing that DAPs are not the best way to go, limited, and not well
supported for 2007. What are the best options to go forward with this
project? Thanks in advance!!!

 

[cmarsh]

To add a little more info to this, the project will be used on an Intranet.
Thanks again

 

[Arvin Meyer [MVP]]

First, I'd determine if you really need the web. If you will never have more
than a dozen or so concurrent users, you can easily use terminal services,
at a far lower cost that creating a web application. I've used Access 2002
on a beefy server with more than 2 dozen users.

By using Access as a rapid application development tool, you will save far
more in labor costs unless you have only a form or 2 and now other
significant development. You can use (in decreasing order of expense):
Citrix, Microsoft Terminal Server, WinConnect:

http://www.citrix.com/lang/English/home.asp

http://www.microsoft.com/windowsserver2003/technologies/terminalservices/default.mspx

http://www.thinsoftinc.com/product_thin_client_winconnect_server_xp.aspx

I think that this is the overall easiest and cheapest solution, and using it
through a VPN probably the most secure, as well. But if you expect more than
a dozen users, you should consider an asp/asp.net solution instead. The
development time and expense will be 3 to 6 times higher (maybe even more),
but you will be able to use it publicly over the Internet with a significant
number of users. If you do have a large number of users, it would also be
better to have a SQL-Server back-end.