Steve said:
I am begiinning to look into creating a web
page and I also need to learn how to create
a database for my wife's clients. Is this two
seperate projects or can they be integrated
to work with each other?
A database created with Microsoft Access can be used on a website... that
is, Tables and Data, with Relationships... actually a "Jet database" (.MDB)
from the Jet database engine that is the default for Access. The ACCDB
databases of Access 2007 can also be used. But, they can be used only on
Windows servers -- if your website is hosted on a Linux or Unix server, you
cannot use an "Access" database.
However, the user interface can not be directly transferred. For a few
versions, there was an option for Data Access Pages, but it was not widely
accepted because of its limitations and the ability to create and maintain
DAPs has been dropped from Access 2007.
You can create your website using Microsoft Front Page with the Database
Interaction Wizard (simple access and presentation only), the new Microsoft
Expression Web, or Active Server Pages (.asp) or ASP.NET (.aspx), or other
technologies (Visual Basic 6.0 or earlier, or VisualBasic.NET).
That said, most websites use server databases for their datastore, either
Microsoft SQL Server, or other Server databases. If you have Access on a
machine on the LAN with the server, and the database being used is
ODBC-compliant, you can connect to the server's database for maintenance and
updates -- using the LAN for client-server access and the Internet or an
intranet for web access.
Larry Linson
Microsoft Access MVP
