database website

  • Thread starter Thread starter iridium
  • Start date Start date
I

iridium

Is there an easy way to use frontpage to convert MS access database. I
have mid size database that I would like to convert to a webbased. Is
there an easy way of doing it? (a third party software, using
frontpage or dreamweaver etc.) I would appriciate any comments.

Best regards.
 
No, you cannot convert an Access database. If you store the Access database
tables on the server where your FrontPage website runs, you can use the
Database Interaction Wizard to do simple (I emphasize _simple_) database
access from FrontPage.

Access has a feature called Data Access Pages, but its limitations are such
that it is rarely used other than on intranets, and, according to the Access
developer's blogs, is being "deprecated" in the next version, Access 2007. I
wouldn't recommend it, unless you are sure you can live with the limitations
and are able to keep Access 2003 for any maintenance that it might need.

Larry Linson
Microsoft Access MVP
 
Larry; thank you for the speedy reply.

So what would be your suggestion in terms of converting the DB to web.


Best regards

Zeki
 
"iridium" wrote
So what would be your suggestion
in terms of converting the DB to web.
Click to expand...

That would depend on your needs and on the environment available to you at
the web server. If the web server is running Windows, you can use ActiveX
Server Pages (.asp) or the newer ASP.NET to create a web application that
uses either your Access tables, or uses those tables re-created in MS SQL
Server and populated from your Access tables.

Both of those have some learning curve, and converting a vital business
application isn't likely the easiest way to start.

If your web server is running Linux or Unix, then you'll likely have to
convert your data to whatever database it provides and use a different
language to create the application. I don't know enough about those
environments to make useful suggestions.

And, as I said, if the web server runs Windows and the data handling
requirements are simple, Front Page and the Database Interaction Wizard
would be the easiest approach to implement, but the least flexible.


Larry Linson
Microsoft Access MVP
 
Back
Top