Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've done load testing on a web application already using tools like JMeter, and tested my database for transactional integrity.

But are there any tools for testing an ODBC connected database (like MS-Access) using just the database?

I'd like to be able to simulate a real world situation of multiple connections reading and writing to and from the database. I want to use this tool to prove something will work before I put it into production.

share|improve this question
Performance testing Access? – Phil Aug 16 '12 at 15:51
@Phil Well performance testing MS Access sounds silly I know...I'm really just trying to prove that using another tool (which I'm pretty sure only reads the size of the file) won't corrupt the MS Access database while multiple users are accessing it. – leeand00 Aug 16 '12 at 16:02

The IT shop I work for "bleeds blue" (ie, sticks mostly to IBM tooling), so the performance software we use is IBM's Rational Performance Tester (RPT). IBM's stuff isn't (usually) free or cheap, but RPT has helped us to populate our databases through our applications (mostly because the relationships among the tables is too complex to do nicely via script).

That being said, we are also considering using a tool like the following data-generator, in order to better be able to mass insert data into our database for performance testing.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.