How can I convert an Access db to a Web site?

[M Skabialka]

I have an Access 2000 database which is used by many people, broken up into
a front and back end.

I have been asked to convert it into a Web-based product.

I have a copy of Front Page 2003 Beta, and was told all I had to do was
import the Access database into Front Page and it would convert all of the
pages and 6,000 lines of VBA code and I would then have everything I needed
to create the web-site.

Well, having no idea how Front Page works (took a short class a few years
ago), the few things I tried failed miserably. I have been able to get
access to the Back End, but have no idea how to convert the forms, reports,
queries, VBA and modules to pages I can use on a web site.

Can anyone steer me in the right direction?

Thanks,
Mich

 

[M Skabialka]

I had a gut feeling this wasn't going to be easy!
I will look into what you suggested,
Thanks

Mich

 

[GVaught]

You don't import the Access database into FrontPage.

You can create forms within FrontPage that can connect to various tables and
either write or retrieve data. However, this isn't the most user friendly
way. Also, if your client is expecting the same functionality that Access
provides, he/she will sorely be disappointed.

Before you turn your database into a web-based product find out exactly what
your client means. Have him/her spell out what he/she expects. FrontPage may
not provide the functionality you need. It may call for writing .ASP or
ASP.Net web services. Find out how many users will use the web-based
application once it is completed. If you will have more than 15 concurrent
users, you want to move up to SQL Server. Access isn't designed to handle
lots of web hits. Also, you need to find out if the pages will be stored on
a local webserver that you have control over or at an external ISP's web
server site. The external ISP site must be able to handle .ASP or FrontPage
Extensions and MDB files.

You can create Data Access Pages, however they have their limitations also.

 

[Mark Andrews]

Look into ASP or ASP.NET for creating your front-end. Also you will need
some Javascript programming for client side code.

Lots of examples out there. Steal as much code as you can.

If you want to get your reports on the web checkout our product which
lets you get Access reports on the web with very minimal effort.
http://www.rptsoftware.com
Possibly you can start by making a web page for user to retrive reports
and have the data entry people keep using Access?

I agree with the other post about probably thinking about SQL Server
(except for small Intranet apps or apps where you are viewing data but not
updating data very much).

HTH,
Mark
RPT Software
http://www.rptsoftware.com