Link to home
Start Free TrialLog in
Avatar of sanjusambhe
sanjusambhe

asked on

MS Access

What propblem can be faced if Ms access is used for multiuser application?
Avatar of pamboo
pamboo


In MS Access , maximum of only 255 users can access concurrently. Whereas for MSDE/SQL Server it is Virtually unlimited number of concurrent users

On more abt MS Access Perfromance , refer the below links .

http://www.microsoft.com/resources/documentation/sbs/4.5/all/reskit/en-us/part9/sbrk0945.mspx



ASKER CERTIFIED SOLUTION
Avatar of ankuratvb
ankuratvb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You always have the option of using MySQL which is free.or trying the high-end ORACLE or SQL Server
Do a google with:

http://www.google.co.in/search?sourceid=navclient&q=MS+access+bloat+problem

You will find plenty of instances of the bloating problem.

If u don't want your http://www.google.co.in/search?sourceid=navclient&q=MS+access+bloat+problem

If your application wont be running 24x7,You can still risk using it.

But otherwise,Its a No-No situation.
Oh!What did i do to deserve a 'C'.