Access and Frontpage

[tina.boroff]

I have just created a form for a Maintenance Database that has alot of
VB code involved. Now they want the form on our Intranet instead. Is
there a way that anyone knows to publish the form including code, data
sources, etc to the internet. I am using Frontpage and Access 2003.

Thanks
Tina

[Larry Linson]

<ti*********@gm ail.com> wrote

I have just created a form for a
Maintenance Database that has alot of
VB code involved. Now they want
the form on our Intranet instead. Is
there a way that anyone knows to
publish the form including code, data
sources, etc to the internet. I am using
Frontpage and Access 2003.

You could use Access' Data Access Pages, if all your users on the Internet
use Microsoft Internet Explorer 5.5 or later and have the Office Web
Extensions installed. It does not have the full "rich client" capability of
an individual or multiuser Access application.

There's no way to publish an Access application (e.g., forms and code) to
Front Page, but if the UI is very simple, you can use Front Page's "Database
Interaction Wizard" to create a website that provides access to an Access
database. (You can gain flexibility by creating ASP pages and inserting them
into your Front Page website. ASP pages do not use VBA like Access, but you
can use vbscript or javascript code. This would not be a "trivial exercise",
however.)

Larry Linson
Microsoft Access MVP

[tina.boroff]

Larry, I am finding out the it isn't trivial

I have been playing with data access pages. However, I have alot of
fairly simple VB that doesn't seem to translate into VBSCRIPT. Simple
like enabling and disabling boxes, filling in boxes based on the answer
in a first box.....Just when I was getting a handle on some VB now it
looks like I have to change everything. I take it there is no 'easy'
way to make a data access page and include the VB script?

[Larry Linson]

Alas, because of the limitations, I have not worked with Data Access Pages.
Thus, I don't try to advise on DAP details.

On projects where an Access database was needed on the Internet or an
intranet, I was lucky to have colleagues who were very good at asp pages and
third-party products like Cold Fusion.

A browser just does not have the features that a rich-client application
such as Access does, so a direct translation is not going to be easy. I
suspect that you can accomplish your purpose, thought not duplicate your
rich-client app, with asp pages and vbscript or, if your company/client is
using .NET, with ASP.NET and VB.NET.

Larry Linson
Microsoft Access MVP
<ti*********@gm ail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Larry, I am finding out the it isn't trivial

I have been playing with data access pages. However, I have alot of
fairly simple VB that doesn't seem to translate into VBSCRIPT. Simple
like enabling and disabling boxes, filling in boxes based on the answer
in a first box.....Just when I was getting a handle on some VB now it
looks like I have to change everything. I take it there is no 'easy'
way to make a data access page and include the VB script?

[Bob Alston]

ti*********@gma il.com wrote:

I have just created a form for a Maintenance Database that has alot of
VB code involved. Now they want the form on our Intranet instead. Is
there a way that anyone knows to publish the form including code, data
sources, etc to the internet. I am using Frontpage and Access 2003.

Thanks
Tina

Don't even try to use Data Access Pages unless the implementation will
be on an internal intranet. Web servers for internet deployment will
not allow the underlying access that Data Access Pages use.

I found one software that will translate web pages. I had a bit of
problems with it the 2nd time I tried. Your mileage may vary. Scroll
down in the link below til you see the section on
Microtools Access Wiz - MS Access to .NET Converter

http://members.cox.net/tulsaalstons/...20Internet.htm

Bob