Last post Sep 07, 2010 12:16 PM by cpt_safety
Sep 07, 2010 10:54 AM|cpt_safety|LINK
Here's my situation: we are a manufacturer. We have our order database in an Access database (insert any criticism here). This database is stored on our internal Windows 2003 file server. I would like to give our sales department online access to some
of this data (order numbers, status, shipping details, etc.) via our web site which is is hosted by NetworkSolutions.
The sales department could have secure online access to a section of the website closed to retailers and public. That is set up now via ASP.NET and a hosted SQL database. I would like to import a limited amount of our order database online on the SQL database
online. Is it possible to set up some sort of scripting that will update the online SQL database hourly? Would it be better to put a database on our web server and run any scripts internally between our file server and our web server (web server is not member
of file server domain)?
Sep 07, 2010 11:25 AM|riswadkarharshad|LINK
As far as I know, Access DB does not allow multiple users to access/edit the same records, though I am not sure if its changed in Access 2007.
You can create a batch script of your queries on server which can be run hourly.
Sep 07, 2010 11:27 AMfirstname.lastname@example.org|LINK
Yes. ofcourse you can do it
You can create a SSIS (integration service) package to import the file from your file server for DB
Add the SQL Job scheduler to run hourly or whatever frequency you want. Thats it.
Sep 07, 2010 12:16 PM|cpt_safety|LINK
Thank you for you quick replies. I'll get to work.