HTML and MS Access

[John Baker]

Hi:

I am URGENTLY in need of some book or web site OR tool that will help me integrate a
relatively simple MS Access application into a web page or pages. This is a time recording
system (by project), and I would be more than willng to pull the updated database down
from the Host using FTP on a monthly basis. Its just that I need to understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97 had a wizard that
permitted the creation of web pages, and wonder if that wizard is available as an add on
to other versions of Access.

Thank You

John Baker

[Philip Herlihy]

1) Which version of Access are you using now?

2) What *exactly* do you want to do?

3) What server-side scripting does your Host support?

4) What tools do you use to create web-pages?

Access 2000 can save tables, queries and reports as HTML (or even ASP).
FrontPage can interact with Access databases very easily if you have the
FrontPage Extensions on the server. ASP.net can use Access databases. Etc,
etc... You may also be able to use an ODBC connection on a server that
otherwise wouldn't support Access.

From the sound of it, you want users to update their times via the web, and
obtain reports at monthly intervals. To do this, you'd need to create a web
form, with connections to a database on the server. Those connections are
made using the server's native scripting language. In the Microsoft world,
this will be ASP or the newer ASP.net. Access 2000 and later has "Data
Access Pages" but users need an Office license on their client machines to
make this work (never tried it). FrontPage, as I said, makes this very easy
if you have a server with the FrontPage Extensions installed - very little
configuration or programming needed in this case. You can make a start with
ASP.net (provided your server is so equipped - you only need Windows 2000 or
later plus the "framework") using the free WebMatrix tool, and the book
"Teach Yourself ASP.net in 24 hours". I'm no great expert in any of this
(only a dabbler) but that's a start. You may also get help in ASP or
ASP.net or Access newsgroups.

--
####################
## PH, London
####################
"John Baker" <Ba******@Verizon.net> wrote in message
news:se********************************@4ax.com...

Hi:

I am URGENTLY in need of some book or web site OR tool that will help me
integrate a
relatively simple MS Access application into a web page or pages. This is
a time recording
system (by project), and I would be more than willng to pull the updated
database down
from the Host using FTP on a monthly basis. Its just that I need to
understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97 had
a wizard that
permitted the creation of web pages, and wonder if that wizard is
available as an add on
to other versions of Access.

Thank You

John Baker

[Philip Herlihy]

While I think of it - Dreamweaver MX 2004 has some nifty tools to get you up
and running with ASP.net or ASP, and the "Getting Started" tutorials (the
sections on "Web Applications") will, um, get you started fairly quickly.

--
####################
## PH, London
####################
"Philip Herlihy" <fo******@herlihy.eu.veil.com> wrote in message
news:cu**********@sparta.btinternet.com...

1) Which version of Access are you using now?

2) What *exactly* do you want to do?

3) What server-side scripting does your Host support?

4) What tools do you use to create web-pages?

Access 2000 can save tables, queries and reports as HTML (or even ASP).
FrontPage can interact with Access databases very easily if you have the
FrontPage Extensions on the server. ASP.net can use Access databases.
Etc, etc... You may also be able to use an ODBC connection on a server
that otherwise wouldn't support Access.

From the sound of it, you want users to update their times via the web,
and obtain reports at monthly intervals. To do this, you'd need to create
a web form, with connections to a database on the server. Those
connections are made using the server's native scripting language. In the
Microsoft world, this will be ASP or the newer ASP.net. Access 2000 and
later has "Data Access Pages" but users need an Office license on their
client machines to make this work (never tried it). FrontPage, as I said,
makes this very easy if you have a server with the FrontPage Extensions
installed - very little configuration or programming needed in this case.
You can make a start with ASP.net (provided your server is so equipped -
you only need Windows 2000 or later plus the "framework") using the free
WebMatrix tool, and the book "Teach Yourself ASP.net in 24 hours". I'm no
great expert in any of this (only a dabbler) but that's a start. You may
also get help in ASP or ASP.net or Access newsgroups.

--
####################
## PH, London
####################
"John Baker" <Ba******@Verizon.net> wrote in message
news:se********************************@4ax.com...

Hi:

I am URGENTLY in need of some book or web site OR tool that will help me
integrate a
relatively simple MS Access application into a web page or pages. This is
a time recording
system (by project), and I would be more than willng to pull the updated
database down
from the Host using FTP on a monthly basis. Its just that I need to
understand how to set
it up on the web site itself. The Host supports SQL.

Any direction you can give would be much appreciated. I know Access 97
had a wizard that
permitted the creation of web pages, and wonder if that wizard is
available as an add on
to other versions of Access.

Thank You

John Baker

[Lachlan Hunt]

John Baker wrote:

I am URGENTLY in need of some book or web site OR tool that will help me integrate a
relatively simple MS Access application into a web page or pages...
You should try asking this question in a newsgroup/forum/mailing list
related to server side processing, such as PHP, JSP, ASP or whatever
else you want to use.
Any direction you can give would be much appreciated. I know Access 97 had a wizard that
permitted the creation of web pages, and wonder if that wizard is available as an add on
to other versions of Access.

Don't use it. Like all MS Office products, it will generate invalid
HTML (tag-soup), most likely filled with tons of useless proprietary
extensions.

--
Lachlan Hunt
http://lachy.id.au/
http://GetFirefox.com/ Rediscover the Web
http://SpreadFirefox.com/ Igniting the Web

[Michael Vilain]

In article
<42**********************@per-qv1-newsreader-01.iinet.net.au>,
Lachlan Hunt <sp***********@gmail.com> wrote:

John Baker wrote:

I am URGENTLY in need of some book or web site OR tool that will help me
integrate a relatively simple MS Access application into a web page or pages...

You should try asking this question in a newsgroup/forum/mailing list
related to server side processing, such as PHP, JSP, ASP or whatever
else you want to use.

Any direction you can give would be much appreciated. I know Access 97 had
a wizard that permitted the creation of web pages, and wonder if that wizard is available
as an add on to other versions of Access.

Don't use it. Like all MS Office products, it will generate invalid
HTML (tag-soup), most likely filled with tons of useless proprietary
extensions.

To quote T'Pow: "I grieve with thee"

php could do this, but only on your local machine through the COM
object. It will require programming to get it going. There are books
out there that would discuss integrating web sites and databases but the
most often used combo with php is MySQL. MS Access is a single-user
database not meant to be shared amongst multiple accesses. I like the
O'Reilley books (http://www.ora.com), but YMMV.

Try your local technical book store to find books that work for you,
then buy them on-line.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[Blinky the Shark]

Michael Vilain wrote:

php could do this, but only on your local machine through the COM
object. It will require programming to get it going. There are books
out there that would discuss integrating web sites and databases but the
most often used combo with php is MySQL. MS Access is a single-user
database not meant to be shared amongst multiple accesses. I like the
O'Reilley books (http://www.ora.com), but YMMV. Try your local technical book store to find books that work for you,
then buy them on-line.

I've had good luck with http://overstock.com having the O'Reilly books
I've craved, and at very good prices. I am not associated with them in
any way.

--
Blinky Linux Registered User 297263

Who has implemented Usenet Solution #45933:
Now killing all posts made with User-Agent G2 (Google Groups)