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]

Re: HTML and MS Access

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" <Baker.JH@Veriz on.net> wrote in message
news:se0a01d972 lb1egvsrkg9tt98 q7conv07u@4ax.c om...[color=blue]
> 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[/color]

[Philip Herlihy]

Re: HTML and MS Access

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" <foof8501@herli hy.eu.veil.com> wrote in message
news:cu35su$c85 $1@sparta.btint ernet.com...[color=blue]
> 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" <Baker.JH@Veriz on.net> wrote in message
> news:se0a01d972 lb1egvsrkg9tt98 q7conv07u@4ax.c om...[color=green]
>> 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[/color]
>
>[/color]

[Lachlan Hunt]

Re: HTML and MS Access

John Baker wrote:[color=blue]
> 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...[/color]

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.
[color=blue]
> 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.[/color]

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]

Re: HTML and MS Access

In article
<420b143d$0$148 4$5a62ac22@per-qv1-newsreader-01.iinet.net.au >,
Lachlan Hunt <spam.my.gspot@ gmail.com> wrote:
[color=blue]
> John Baker wrote:[color=green]
> > 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...[/color]
>
> 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.
>[color=green]
> > 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.[/color]
>
> 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.[/color]

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]

Re: HTML and MS Access

Michael Vilain wrote:
[color=blue]
> 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.[/color]
[color=blue]
> Try your local technical book store to find books that work for you,
> then buy them on-line.[/color]

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)