I can't say as I have worked much with this. But I have seen people develop ASP pages using FrontPage. On an intranet you're pretty secure to have those ASP pages making connection directly to the data in your Access database. But that would be more or less rewriting any functionality you already have in your databases.
As far as calling existing modules in your Access database, I'm no help.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group