The only problem  see here is that ms-access is not a web based application.
So, I can't see how possibility ms-access figures in the picture here.

You can certainly set-up and create your data tables using the MSDE and use
ms-access to create those tables etc. However, you can also use the
Enterprise Manager for sql server to also do this.

You ADP forms, code and reports have absolute nothing to do with a web based
system.

When you use a web based system, you don't need, or nor use ms-access.
Ms-access is a developer tool for windows just like VB or C++ (both again of
which also are of little use when it comes to building a web based
applications).

If you are asking can you use a ADP project in place of the sql Enterprise
manager to create your tables etc, then the answer is yes...but your ADP
projects forms and reports etc will be of no use to the web server that
connects to the sql server.

--
Albert D. Kallal     (MVP)
Edmonton,  Alberta Canada
kallal@msn.com
http://www.attcanada.net/~kallal.msn