Max Number of users with access Backend?

R

rico

Hi all,

How many users connecting to an access back end would you advise before
going to mysql or sql server?

I currently have 10 users. Should this be ok? Have been having some
slowdowns in the system recently - taking long time to display info. Is this
because im using access as the backend or could there be other problems?

TIA

Rico
 
A

aaron.kempf

MDB as a backend is a ridiculous architecture.

I would either use mySql or SQL Server.

when you say 10 users-- are they in the application ALL DAY LONG?

Access Data Projects are a great option; i would look into some issues
first.

MSDE could work perfectly for that many users.. it's just tough to know
enough about your whole situation.

-Aaron
ADP Nationalist
 
J

Jerry Whittle

Microsoft says 255 users in the same MDB file, but then MS has been known to
tell a whopper or two like Windows 95 would run well on 16mb of memory.

I've seen well designed Access databases running just fine with 25 uses.
I've seen poorly designed databases crawl with 5 users. Your 10 users should
be no problem.

The big question: Do each of the users have their own copy of the FE on
their computer? If not, such as they all use the same FE out on the network,
that could be the problem right there.

Other things to look at would be disabling Name AutoCorrect. Doing away with
lookup fields at table level. Make sure that any combo boxes on forms don't
have more than 100 items to pick from.

Of course it could just be the network and not the database at all.

Here's a good web site on Access performance problems:
http://www.granite.ab.ca/access/performancefaq.htm
 
A

aaron.kempf

split front ends and backends?

you don't even HAVE a backend when you use MDB.

Access Data Projects gives testosterone to your Access applications.

-Aaron
 
R

rico

Thanks jerry,

yes the users all have thier own front end. Thanks for your suggestions.

Rico
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top