Access 2003 backend to Web frontend

[DeborahP]

Hello,

I have been asked to design a database to attach to a website. The website will allow browers to request information about the company. The client wants to capture this information and generate a database so reports and labels etc.. can be developed.

I can design the database with no problem...it is connecting it to the website I do not know. The website is created in PHP and HTML. Can someone answer these questions below?

Once the user clicks on the submit button - what do I do?
Can the client use the database from a switchboard or only on the web? He wants to produce reports, add inventory, check sales, etc.
I have heard that it would be better to use Mysql however the client wants access - I know it is possible - can you direct me to a book or website to learn more about this?

Thanks in advance.
Deborah

 

[KenHigg]

The quickest way is with .asp or Cold Fusion. (In my opinion)

 

[muzza79]

Hi Deborah,

I have recently started the development of a PHP site myself and have found the following useful.

http://www.php.net
This is the main website for PHP and the source of a great deal of related information. It also has tutorials that you may find of use.

http://www.devshed.com/c/b/PHP/
http://www.phpbuilder.net
Another couple of websites that showed up when I checked google.

As for books just check Amazon for PHP, then read the reviews that people leave and pick a goodie!

As for using ASP instead, that is a matter of choice, i wouldn't say one was any better than the other. However I would recomend using MySQL instead of Access. (It's open source so why not?)

Cheers Murray