Give customers access to DB from web form

[asteadman]

Hi all,

Looking for some advice. I would like to allow my customers to access my internal database (MS Access .mdb) to see what orders they have placed.

I need a web form where they can enter their ID and this would run a query (data from 2 tables) and show them another form which would show their orders.

The web database only needs a a small part of the data and none of the existing functionality. I was wondering if anyone knows the easiest way to connect the 2 databases together (mySQL connection maybe) and produce the necessary forms?

 

[asteadman]

Hi Pat, thanks for the reply. As this is new territory for me could you recommend...
1 - method for exporting the tables
2 - how to update them on the externally hosted web server, ftp?
3 - what software would you use to create the asp pages? I haven't web developed for a while.