Access97 Performance

I currently have a networked Access 2.0 application that, obviously, is having some performance problems.  I have users running over a WAN.  I am in the process of selecting an upgrade platform and I am considering Access 97.  Can anyone tell me whether Access 97 should provide the performance enhancements I need over a WAN?
mhyoheAsked:
Who is Participating?
 
cymbolicConnect With a Mentor Commented:
Not Much.  YOur basic problem is that Access applications much more resemble file server applications rather than database server applications.  The problem is that most of the processing and filtering is done down on your local machine, and the records must be passed down en masse in order to be selected.  Other problem is that certain queries will escalate locking up to the table level, whle the basic page locking mechanisim is not real good either, and no better in Access 97.  

Applicatins can often tolerate these behaviours on a high bandwidth local area network, but suffer from the real available bandwidth on a WAN.  
0
 
cymbolicCommented:
SQL Server will perform much better on a WAN, because filtering is done on the server, and only the selected records are returned across the nework to your client machine.  However, this is dependent upon the quality of the program implementation.  If you insist on filling a list box with 10,000 records so your user can scroll through and select on of them, and you bring them down as updateable, then neither database will be much good for you.

I recommend "Hitchiker's Guide to Visual Basic & SQL server" by W. R. Vaughn, for a more detailed comparison of the two methods, and for what to expect when using MS Access.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.