What are the Record Size Limitations of Access 97/2000/2002

[MikeFL]

I trying to find out what the file/record size and the Network “Limitations” are of all versions of MS Access programs (97, 2000, and 2002). I tried looking for this information on the Internet and struck out!

We were running a program using Access 97 with over 366 records in it ok, just a little slow. Then my boss told me we had to upgrade to Access 2000 to speed up the program and make it a "Multi user" capable program. We did and now the program runs even slower! Some programmer’s told him that we must go to Microsoft Sequel to make the program run faster. Access 2000 can’t do it.

I don’t believe the programmers! I believe they are just trying to sell us on using Microsoft Sequel so that I can’t access the program data like I can now.

Can some help me? mike_e@msn.com

 

[joshuar]

How do you have your database architecture set up? Does the front end reside on the server or on each pc? You really don't need SQL Server for 400 rows of data.

You should probably take a look at your forms and the data they are retrieving as well. Are you retrieving pictures? Are you retrieving more data than you need to in the form of a list box or subform?

If your database is properly setup, try running Network Monitor and Server Monitor. Is network traffic particularly bad or are packets being dropped? Are your server cpu's overtaxed? Are you running out of memory on your server or workstation?

There are better ways to improve performance on such a small database than moving to SQL Server. Moves to SQL Server are more appropriate for databases with thousands of rows or databases requiring dynamic backups, strong security, or protection against deletion.

-Joshua

 

[MikeFL]

Thanks Joshua:

I agree with you and I believe there just trying to sell us on a more expensive program so they won't have to rewrite this one at their expense. They converted it from Access 8.0 and now it runs slower!

I did not design this program; it was some outside company. It's running on a standalone 1.3GHz P4 computer with 128MB RDRAM. I believe the structure of the program is bad.

Ps: Can you tell me what the file/record size (i.e., 1GIG, 100,000 records, etc.) and the Network “Limitations” are of all versions of MS Access programs (97, 2000, and 2002). I tried looking for this information on the Internet and struck out!