Max Number of users with access Backend?

[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

 

[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

 

[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

 

[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

 

[rico]

Thanks jerry,

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

Rico