I'm fairly new to Access (I've worked with Oracle and MySQL in the
past). I was asked to build an application for a small office and told
that I had to use Access 2002. I was VERY uncomfortable with this, but
went ahead anyway. So two weeks ago we rolled out the new system and
I'm still wondering how robust Access is......I know it's not in the
same league as Oracle, but at the same time this isn't a real big
application. But I can't help but worry if it's going to hold up in our
environment over time. So far we haven't loaded the database with many
records -- but that's coming soon and I am worried.
We will have 5-10 concurrent users at any given time, but much of their
activity will simply be reading records. But there will be moderate
updating of records throughout the day. The database is split with
forms on the client machines (running XP Pro) and the backend on a
server (but it's all MS Access 2002, I was told I couldn't use MS Sql
Server). The database is 25 tables with roughly 400 fields spread
across these 25 tables. We will have roughly 10,000 records in the
database at some point.
Does this sound like it's something Access 2002 can handle ok? Thanks
in advance for your help! Reassure me so I can sleep at night :-)