Stress testing an Access application

[ebnemik]

I was wondering if it is possible to impose a stress test on an existing Access 2000 application. I would like to know if anyone knows if there is a tool avaialble or how I would going about seeing if my databases are going to be able to handle the added records.

What about possible performance issues? I know this is very general, but I am looking for a starting point.

thanks

 

[OnTheFly]

A lot is going to depend on what you are using for a backend. If you are using Access to Access, are going over a network and using Access 2000 you may have performance issues. (I did.) If you are using SQL or Oracle you will get better performance over a network.