rebuilding Access forms in HTML

Hi,

I have built an Access database, split in frontend and
backend. The backend holds the tables, the frontend holds
the forms, queries, reports and VBA modules.
Most forms and controls in the forms are maintained by or
trigger event procedures. Most data loaded in forms are
generated by queries rather than picked directly from the
tables. The database is able to produce Access reports,
but also exports data to Word and Excel files, for
instance by picking data from controls, and dropping them
at bookmarks in Word templates.

My client has asked me to rebuild the frontend in HTML,
without loosing any of its functionality, like
locking/ulocking fields, running (VBA) validation,
connecting to Word templates, and exporting to Excel.

Is this possible, and if yes, how. I am quite familiar
with Dreamweaver, but I have never used it for presenting
and updating databases. I guess the key question is how
to produce webpages that have the same VBA managed
functionality as my Access forms?

Thanks for any guidance on how to approach this.

Bakema

simply forget it (way to costly) ;-)
Seriously - you would have to use a proper SQL backend (MS/oracle) before U
even thinkthe thought...

Pieter

"Bakema" wrote in message
...
Hi,

I have built an Access database, split in frontend and
backend. The backend holds the tables, the frontend holds
the forms, queries, reports and VBA modules.
Most forms and controls in the forms are maintained by or
trigger event procedures. Most data loaded in forms are
generated by queries rather than picked directly from the
tables. The database is able to produce Access reports,
but also exports data to Word and Excel files, for
instance by picking data from controls, and dropping them
at bookmarks in Word templates.

My client has asked me to rebuild the frontend in HTML,
without loosing any of its functionality, like
locking/ulocking fields, running (VBA) validation,
connecting to Word templates, and exporting to Excel.

Is this possible, and if yes, how. I am quite familiar
with Dreamweaver, but I have never used it for presenting
and updating databases. I guess the key question is how
to produce webpages that have the same VBA managed
functionality as my Access forms?

Thanks for any guidance on how to approach this.

Bakema