Access 2000 and Data Access Page

I have hosted a web site with Access database. I am trying to create
Maintenance Dataentry forms to add/change/delete records from this hosted
Access database. These forms are for my use only and not for the site users.

I am trying to avoid developing long winded ASP programs and found out that
Access generates ASP files. I have tried in both Access versions.Following are my issues with Access 97 and 2000.

Access 97:
Example Student.Asp and Studentalx.asp
Generates two ASP files from the Export wizard (one with alx suffix).
Creates Record Add/change/del options
When I run it (in localhost itself), Student.asp shows a box with no data
and Studentalx.asp shows a record with nav buttons. But is not fully
functional.

Can you tell me the steps I am missing in generating?


Access 2000

- Have a new feature to generate "data access page" which generates htm files
- works fine on the localhost. - when hosted does not able to point to the database on the web server. Under <Object> tag the local database is linked. I changed this to server side as my database is on a web site. When executed this asks for Data Source Logon. This was not required for local access.


- How do you make this work with web hosted database?

Any help is appreciated....

I am pretty familiar with ASP, but I did not read your whole question...however I would suggest posting it on www.asp101.com, it has a very good general forum for questions like you have asked.