By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Access and Frontpage

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
<ti*********@gmail.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

Nov 13 '05 #2

P: n/a
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?

Nov 13 '05 #3

P: n/a
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*********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.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?

Nov 13 '05 #4

P: n/a
ti*********@gmail.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
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.