Hi
I have an old/small Classic ASP webapp on my development PC that uses SQL.
I want to be able to deplay this app to a laptop that only has IIS on it. The laptop will not have SQL installed on it (it is out of my control) so I think just having an Access backend will be fine. The laptop will be used offline hence why I can't have a remote SQL setup either. It will only be used by one person at any one time so there will be hardly any database activity hence why Access would be fine.
The webapp is just a series of forms that helps with entering data. Once filled out the forms are submitted and stored in the database until all forms are complete. Once all forms are complete the user hits a 'Send' button which mails out the data stored and then empties the tables in the database.
When they send the data they will be connected to the net so this the chance where my check script runs. It compares the version number stored in the 2 databases. If the one on the laptop is less than the SQL one then (after notifying the user and the user acknowledging it) I want an Update script to run. The script just needs to create/copy tables from SQL into the Access database. If a table already exists it needs to be dropped and recreated obviously as the SQL source will always contain the latest format/data.
I have searched and well...can only find 'Access to SQL' scripts/help but nothing the other way round.
I am not so much after the complete solution as such (unless its out there :P ) but more advice/links to sites that have help/information etc.
Thanks all.
Start Free Trial
