Damon,
I forgot to mention -- theme park has a "daily" report that multiple
departments MUST enter data into during the day and evening. It resides on a
shared server.
Can't tell you how many times I would be leaving at night listening to a
supervisor groaning because the sheet was open on another PC whose user had
gone home for the night.
I have an application at work that should be in a dBase -- don't know enough
about Access to set it up, can't find an off the shelf product to do the job
and, agency has $0.00 for me to do the project.
Retirement, where art thou.
"Damon Longworth" wrote:
It is not unusual to see Excel used as a database. Excel is a great tool,
but was not designed to be a database. Just as it was not designed to be a
word processor. Excel is part of a "suite" for a reason. Each part has its
function.
Excel can be used as a database, but has its limits. Once the record count
begins to grow into the 10's of thousands, you begin to have problems. At
this point, you find yourself migrating the project to Access where it
should have originated or you try to make the best of a bad situation.
I am not an expert with Access, but can use it. Now, I think about my
projects before I started using Access. It was like working with one hand
tied behind my back. There were so many things that I could not do and now I
do not suffer from those limitations.
--
Damon Longworth
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
"PhilMontUSDA" wrote in message
...
Bob Phillips, Damon Longworth, elusive "Aaron".
I can name a fairly large theme park in central Florida with an
'electrifiying' parent that uses Excel for almost ALL of its day to day
finacial reporting. Creating a new "blank" worksheet each night for the
next
days data.
Oh, there is also a critical system the operates on a Pentium III under --
you'd better be sitting ------- WINDOWS FOR WORKGROUPS 3.11
Talk about coming into the 21st Century. These folks haven't got to the
Future, don't know how they can go Back to the Future!!!
Phil Montgomery