sanjusambhe
asked on
MS Access
What propblem can be faced if Ms access is used for multiuser application?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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'.
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