Hale, Jim
jim.hale at fleetpride.com
Wed Mar 19 12:20:00 CST 2003
Very nice. Thanks Gustav. Jim -----Original Message----- From: Gustav Brock [mailto:gustav at cactus.dk] Sent: Wednesday, March 19, 2003 12:07 PM To: Hale, Jim Subject: Re: [AccessD] Using Access to reconcile store cash Hi Jim With only few forms and a login function, that could be a job for CodeCharge: http://www.codecharge.com /gustav > 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