[AccessD] Using Access to reconcile store cash

ASP is probably the best approach for this.  If you are practicing 'hit and
release', the number of concurrent users is relatively ignorable, since the
chances of having even two people 'submit' their data at the same time is
pretty high....even then it wouldn't be a problem unless you had more then a
hundred or so trying to submit at one time (physically 255 is the limit, but
it might hiccup if a large number submit simultaneously.).

Drew

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