Access FileServer vs MSDE ClientServer

I am designing a new database system for a small team of
users (5-10). I have created similar systems in the past
using an Access FileServer architecture. I am thinking of
using MSDE in the new system to improve performance.
Does anyone have an opinion on whether this would be
worthwhile?
Thanks!
Yes. MSDE (SQL Server) is far more robust in a multi-user environment than
Access. Plus, MSDE offers many more valuable features and functionality than
Access. Several year ago I converted our application from Access to SQL
Server and never once regretted it.
Jim
"Jerry Black" <jerry.w.black@.saic.com> wrote in message
news:2ac201c51e8b$f9c100b0$a401280a@.phx.gbl...
>I am designing a new database system for a small team of
> users (5-10). I have created similar systems in the past
> using an Access FileServer architecture. I am thinking of
> using MSDE in the new system to improve performance.
> Does anyone have an opinion on whether this would be
> worthwhile?
> Thanks!
|||Thanks for the advice.
I'm sure my users will appreciate it.
>--Original Message--
>Yes. MSDE (SQL Server) is far more robust in a multi-
user environment than
>Access. Plus, MSDE offers many more valuable features
and functionality than
>Access. Several year ago I converted our application
from Access to SQL[vbcol=seagreen]
>Server and never once regretted it.
>Jim
>"Jerry Black" <jerry.w.black@.saic.com> wrote in message
>news:2ac201c51e8b$f9c100b0$a401280a@.phx.gbl...
past[vbcol=seagreen]
thinking of
>
>.
>
|||Performance for a small app such as you describe is more contingent on
factors such as database and application design than it is on the
database platform chosen. Some developers have found that the
increased overhead of an MSDE app negatively impacts performance of an
application that worked well in Jet. Whether it is worthwhile or not
will depend on the degree to which you understand the strengths and
weaknesses of the two platforms you are choosing between rather than
the platforms themselves.
--Mary
On Tue, 1 Mar 2005 10:24:58 -0800, "Jerry Black"
<jerry.w.black@.saic.com> wrote:

>I am designing a new database system for a small team of
>users (5-10). I have created similar systems in the past
>using an Access FileServer architecture. I am thinking of
>using MSDE in the new system to improve performance.
>Does anyone have an opinion on whether this would be
>worthwhile?
>Thanks!
|||Jerry,
I'm just finishing converting our billing system which used to run using
an Access database to MSDE/SQL server. Doing the same calculations on a
system after converting lots of code to Stored Procedures has resulted in
about a 4x performance increase for large sets of data. I've also redone
the application in other ways which has reduced memory usage so some of the
performance increase may be due to this as well.
Ron Allen
"Jerry Black" <jerry.w.black@.saic.com> wrote in message
news:2ac201c51e8b$f9c100b0$a401280a@.phx.gbl...
>I am designing a new database system for a small team of
> users (5-10). I have created similar systems in the past
> using an Access FileServer architecture. I am thinking of
> using MSDE in the new system to improve performance.
> Does anyone have an opinion on whether this would be
> worthwhile?
> Thanks!