How to get MS Access Forms to the web quick and inexpenxive?

[dataplayer]

I have a database with a lot of forms built (simple ones) and wish to move them on to the web. But I am new to the .asp web page programming. Up to now, I have hired some pros to build the pages using DreamWeaver. These two forms took almost a year to move on to the web and there are a lot of bugs. The projects cost me a lot of money and wasted time on me to report and test bugs. Can anyone show me how to easily and directly convert these forms to .asp pages or just something that can collect data (The users have to login and submit requests or apply, sometimes change or update info, etc.). That's all I need. I don't need much fancy features. Thanks.

Frank

 

[alsoknownas]

Again, here's the concept:
Since all the data you need is resident in the database, all you need to do is pull it from it with .asp .

Place your database on the server and create a connection to it either DSN-Less or a DSN whichever you want.

1.
Create a simple asp page with an SQL statement pulling all the data from whichever tables you desire just to display it on the screen (thus your first asp page)

2.
Then if you want, you can make a particular field a link to where users can edit the records from that particular record on the link (with me so far?) by adding the ?edit=ID and on the page that this is being linked to, simply request all the field relevant to the url ID you just passed. (Again some knowledge of SQL is required)

3.
Once this edit is running, you simply submit the page to a processing .asp page wich again will contain SQL statements which tell the database which record to update.

4.
An finally since all the information you need, have and has been updated is on the database, all you need to do is simply display it (by pulling it with SQL of course) in any format you wish.

The end

------------------------------------------------------------


An SQL Intro:

http://www.w3schools.com/sql/sql_intro.asp

Adding records to a database thru .ASP:

http://www.stardeveloper.com/articles/display.html?article=2000032601&page=1

Database tutorials:

http://www.katsueydesignworks.com/tutorials_databases.htm

Viewing and Printing Access Reports with ASP and/or VisualBasic

http://www.4guysfromrolla.com/webtech/042600-1.shtml

This should get you going in no time.

[/tt]

 

[dataplayer]

Thanks for the info. It's going to take me a while to figure all this out since I am new. I just started learning about database not very long ago and progress slowly due to the limited time I can devote to it. In the mean time, I am very eager to get the ball rolling. I think I need to hire someone to get the thing started. Could you leave me your email address so that I can contact you for further advice? Mine is frankcheng@adelphia.net. Thanks.

Frank