msAccess capacity

[hpoincare]

I'm intent on using access to manage inventory, trouble tickets, contacts,
and events for a company with 500 users.

Am I asking too much of Access? There will only be about 5 to 10 techs
making entries and I expect to switch to SQL once I have a feel for it but
right now Access is enough of a challenge.

Assuming we have about 50 new records each week - is this practical?

 

[hpoincare]

I found the answers to my questions in the following link

http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

Thanks Albert!

 

[Daniel Pineault]

You could have 2 000 000 users in your company, what is important is the
number of people actually entering data. You state 5-10 techs; Access can
handle this with ease. As for 50 new records a weeks, this too is not a
problem. You don't mention which version of Access you might use in your
devlopment but take a look at
http://office.microsoft.com/en-us/access/HP051868081033.aspx for some specs
on what Access can handle. If you read through some posts on this forum
you'll see mention of people that have dbs with millions of entries without
any issues, so yes Access can handle your needs, based on what you have
stated thus far.

The key to developing a multi-user system like the one your are talking
about is to create you db, secure it, split it and then distribute a
front-end copy to each user.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.