Automated Regression Testing?

[PeteCresswell]

Has anybody found a workable way to do automated regression testing
against an MS Access app?

This, perhaps more than any other feature, is what calls out to me
from VB.NET.

I dabbled in automated testing on another job, but found the tool
sanctioned by the client saw fields on an MS Access Form as bitmap
images - so when writing a script one could only refer to them via
screen coordinates (as opposed to object name). Not a workable
solution IMHO.

Also tried rolling my own application-specific test - with some
success. The increase in comfort level before putting new versions of
the app into production was gratifying,. but developing the routines
was too labor-intensive to scale.

For a bond trading system like the one I'm working on now I envision a
scenario where:
- One starts with a more-or-less empty DB
- Kicks off the regression test
- Goes to lunch
- Comes back to find the DB populated with hundreds of securities/
accounts; a bunch of reports
having been run; and a listing of deviations from expected results
having been created.

Bottom line: has anybody found a tool that allows real-world automated
regression testing of an MS Access app?

 

[Roger Carlson]

Years ago, I used two products by Mercury Interactive called WinRunner and
Quick Test Professional. I didn't use them for testing Access apps, but
they would work. Hewlett-Packard bought Mercury a couple of years ago and I
don't know what they've done with those products. Here's a wiki about it:
http://en.wikipedia.org/wiki/WinRunner

 

[katty]

hello i just wanted you 2 no that i am new here i just wanted to understand
what u guys mean please write back katty!

 

[Clif McIrvin]

hello i just wanted you 2 no that i am new here i just wanted to
understand what u guys mean please write back katty!

Katty -- if you really want to learn what regression analysis is all
about, here's a link that will give you lots of reading:

http://www.goodsearch.com/Search.aspx?Keywords=regression+analysis

 

[PeteCresswell]

Years ago, I used two products by Mercury Interactive called WinRunner and
Quick Test Professional.  I didn't use them for testing Access apps, but
they would work.

Made a post to www.sqaforums.com and it sounds like all MS Office
apps' controls appear as bitmaps to WinRunner.

Somebody suggested another tool called "TestComplete" - which offers a
trial version.

I DL'd the trial and will give it a shot next week.

 

[Tony Toews [MVP]]

Somebody suggested another tool called "TestComplete" - which offers a
trial version.

I DL'd the trial and will give it a shot next week.

I, for one, am interested in your opinion. I've been thinking some
automated tools would be useful at times too.

Tony