Hale, Jim
jim.hale at fleetpride.com
Wed Mar 19 18:04:00 CST 2003
Thanks. This looks like the way to go. Jim H -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Wednesday, March 19, 2003 11:53 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Using Access to reconcile store cash Jim, The web/database, to me, is the best solution. I have a client that started with 50 locations and now has over 70, using multiple pages to send data to the main office. Some have dial-up others broadband. Doesn't matter. Except we did have trouble with any site that was using AOL. Use ASP connecting to an Access mdb. Use NT security. Implementation: Create the ASP pages and the Access database. Move both to an active server. Let your sites know it's location. Use it! HTH Jim -----Original Message----- From: Hale, Jim [mailto:jim.hale at fleetpride.com] Sent: Wednesday, March 19, 2003 11:29 AM To: ''Accessd (E-mail)' Subject: [AccessD] Using Access to reconcile store cash Currently we have 150 stores which fill out a daily cash reconciliation form. Although the form is in Excel the stores currently fax the report to a central location where the cash reconciliation clerk uses the data to reconcile. Clearly the entire process could benefit from some automation. While I can visualize some solutions using a combination of Excel and Access it seems to me that a web form that feeds a database would be ideal. While the data per form is minimal (15-20 data elements/day) I will probably have situations where 20-40 stores need to fill out the form at the same time. Unfortunately I've never done any web work. My questions for the group are: A. Is the web/database the best solution? B. If it is what is the simplest way to implement it? C. Is an Access .mdb the appropriate database i.e. can it handle many simultaneous users? TIA for your ideas Jim Hale _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com