MS Access help

[Anon]

I am trying to set up a relatively small database over my company's intranet that can be accessed via webpages. I am under the constraints that only MS access 97 can be used, and that I can't download any new program utilities ( thanks to company security). Can someone give me an inkling as to how I can go about setting this thing up? I would really appreciate it.

[bastien]

USE ASP or PHP to script access the DB...

If you have Access, I assume you are a MS shop, and therefore are using IIS which has native ASP support...or you can have some one download PHP and configure and install in on IIS.

Then you will need a development environment ( I prefer visual interdev for ASP, though Mcaromedia Dreamweaver MX or Ultradev v4 will work as well) There are also lots of free coding environments available at www.cnet.com in the downloads area.

The coding environments are really only needed to make the development quicker, it can be done with notepad and a good book on ASP (Sam's tach yourself ASP in 21 days is a good one).

Good luck

bastien

[Anon]

Is there any particular reason why you can only use Access?

MySQL is free... I would say that using MySQL instead of Access with ODBC would be faster as well..