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?

 

[Pat Hartman]

I wouldn't recommend allowing direct access to your database. It is too risky. You could create a MySQL or SQL server database that you add orders to after they are entered. You could then create ASP pages to search and display.

You could update the SQL Server database as changes are made in the .mdb or rebuild it nightly which would be simpler.

The Access alternative is significantly more work and requires SharePoint as well as A2013.

 

[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.