471,108 Members | 1,302 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Performance Issues - Access 2000 Frontend SQL Server 2000 Backend

Hi,

Simple question: A customer has an application using Access 2000
frontend and SQL Server 2000 backend. Data connection is over ODBC.
There are almost 250 concurrent users and is growing. Have they
squeezed everything out of Access? Should the move to a VB.Net frontend
taken place ages ago?

Cheers
Mike

Jul 23 '05 #1
4 1637
Hi Mike,
I just completed a similar conversion if that's what you're thinking of
doing. We converted 100 forms, 60 access reports and 15,000 lines of
code "TO" 100 forms, 60 crystal reports, and 75,000 lines of VB.net
code. It was a nightmare. We spent a good 50 percent of our time
chasing down bugs in databinding itself, work arounds for tab controls
that don't work, combo boxes that don't have incremental search like in
access, radio and checkboxes that don't bind to database column nicely
as in Access...let me see, what else sucks about .net,,,Oh, it takes
freakin' forever to load a dropdown compared to access. Crystal is a
pig (eg, 30 seconds of 100 percent cpu to gen one page of output). But
on the bright side, mgmt is buying everyone new Pcs with a gig of main
memory. I guess that's good for someone.

Jul 23 '05 #2


Michael wrote:
Hi,

Simple question: A customer has an application using Access 2000
frontend and SQL Server 2000 backend. Data connection is over ODBC.
There are almost 250 concurrent users and is growing. Have they
squeezed everything out of Access? Should the move to a VB.Net frontend
taken place ages ago?

Cheers
Mike


Converting to dotnet could well be a lot of work for little benefit.
If the system is of significant size then you might well want to take a
look at techniques used in Access to ensure they're IO efficient.
There again, if the system is working fine, why fix what ain't broke.

Jul 23 '05 #3
You should also post this on comp.databases.ms-access.
"Michael" <mi**************@za.didata.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi,

Simple question: A customer has an application using Access 2000
frontend and SQL Server 2000 backend. Data connection is over ODBC.
There are almost 250 concurrent users and is growing. Have they
squeezed everything out of Access? Should the move to a VB.Net frontend
taken place ages ago?

Cheers
Mike

Jul 23 '05 #4
You should also post this on comp.databases.ms-access.
"Michael" <mi**************@za.didata.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi,

Simple question: A customer has an application using Access 2000
frontend and SQL Server 2000 backend. Data connection is over ODBC.
There are almost 250 concurrent users and is growing. Have they
squeezed everything out of Access? Should the move to a VB.Net frontend
taken place ages ago?

Cheers
Mike


Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Trollina | last post: by
5 posts views Thread by Bob Dydd | last post: by
8 posts views Thread by David Kistner | last post: by
42 posts views Thread by PC Datasheet | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.