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
Posted by Philip Herlihy on February 5, 2005, 8:13 pm
Please log in for more thread options
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
####################
> 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
Posted by Philip Herlihy on February 5, 2005, 8:16 pm
Please log in for more thread options
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
####################
> 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
> ####################
>> 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
>
>
XML Sitemap