Access updating or SQL

Question

User1013532281 posted

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)?

Ideas?

-Bill

Answer 1

User-1148431695 posted

Hi,

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.

Answer 2

User-848116622 posted

 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.

Answer 3

User1013532281 posted

Thank you for you quick replies.  I'll get to work.