SQL and Data Access Pages and ASPX pages (1 Viewer)

I have a SQL Enterprise server that I am using a MS Access to remotely access and populate the tables from my laptop into a database.

Based off of the linked data between my project and the true SQL database, I have created some Access Data pages for interacting with the data.

What I need to know how to do is how do I modify the Access Data Pages (source code), so that instead of using my local access project file for source of data it points directly at the SQL database and can operate on the web only interacting with the SQL not my computer anymore.

---Greater detail if I didn't do a good job with the description above---

SQL Server A has database 'Helpdesk'.

IIS Server B for webpages (.aspx).

Computer B has a .ADP (Access Data Project) called 'helpdesk.adp' which is linked via SQL username and password to Server A's 'Helpdesk' database.

Computer B has several Data Access Pages that are used to manipulate the database data.

Problem1: Convert Data Access Pages to normal web pages (.aspx) on Server B so that they talk directly to Server A's 'Helpdesk' database via SQL username and password and no longer care about any reference to Computer B?

Problem2: What functionality from Data Access Pages can not be carried over to a (.aspx)?

Thanks.

.NET is vastly superior to DAP in every way. Whatever you can do with DAP, you can do it better with .NET. I posted a link to MS VS.NET Express which you can download for free until Nov of 06 and ONLY during that time frame will the downloads come with a free life-time license.

Here's the catch. While .NET is superior, it's no where near scripting like ASP3 (classic asp) or vbscript is/was. It's real programming and there is no conversion utility for DAP to .NET that I'm aware of. So you'll have to learn .NET.
Here's the upside. I'm betting that what you DAP's do is relatively basic and can be done with simple forms and/or Grid views and to be honest, it takes all of 10 minutes to make simple GUI's like that in .NET. The difficultly lies in adding advanced features to the controls which require knowlege of how the control works. Out of the box, the gridview supports paging, sorting, updates, deletes but you have to provide that datasource.

For the datasource you can user either a SqlDatasource which is quick and dirty but breaks the nTier model or you can build your own data access class which works with the nTier model and use the ObjectDataSource. The latter will require a bit more work as you will have to provide the methods that require updates,deletes, inserts etc.

If you're serious and you want to get into .NET then I suggest
www.asp.net
www.4guysfromrolla.com
www.learnvisualstudio.net (60.00USD for a lifetime sub & 500+ videos)
http://www.microsoft.com/events/series/msdnaspnetoct.mspx

Thanks Kodo, I will definetly look into the links and information you gave me. You are absolutely correct that it is not anything massively difficult or indepth, just a few querries to fill in some data fields, and user interface areas... like I said it is for generating helpdesk information for customers.

It only has to have some "cheese" and be functional and to the point.

Thanks again.