Database on the Web

[moleary]

How would I go about putting a database on a webpage that my company could access through the web?? How effective would this be? I am trying to network two offices that are at least 2 miles apart and I need suggestions on the most effective way to do this. Thanks!

 

[Kevin_S]

I wouldn't use Access to do this but if this is the medium of choice I would use Data Access Pages. DAP files are forms for MS Access that reside on the web - they are a little stiff so i would recommend ASP but you can go about it with DAP's. For more information search this forum for "Access AND web" and also "Data Access Pages or DAP"

HTH,
Kevin

 

[Autoeng]

You really won't find much info available. The best info that I have found about DAP's is in the Access Developer's Handbook.

 

[moleary]

What do you suggesst to use other than Access??

 

[Kevin_S]

SQL Server 2000/Oracle/DB2 something that is more robust and can handle a lot more users at a time then Access (access is set up to deal with a handful of users at a time while something like SQL Server can handle hundreds without a dip in performance) If your talking web page support you definitly want something that can handle the traffic. I would use ASP to create the forms but thats just my preference since there are many diiferent ways to go about this....

HTH,
Kev

 

[BukHix]

What exactly are you going to do with the database? Are you just gathering form information or do you plan on storing data that neeeds to be secured?