Anyone know of any way of running automated tests against MS Access applications?
Printable View
Anyone know of any way of running automated tests against MS Access applications?
What type of testing are you looking for? Third party program or something custom that you need written?
There are a few decent tester applications (such as WinRunner, Rational Robot and Autotester) that allow you to record a users interaction with an application (e.g. click menu "New", select textbox "Indemnity", enter text "4900.00", click button "Calculate") and then can run playback this interaction as tests again and again so you can do automated front end testing.
However they mostly rely on the windows journal api recording (WH_JOURNALRECORD and WH_JOURNALPLAYBACK) and so are easily confused by Microsoft access forms (for extra credit, this is because the winforms library has a large number of lightweight controls which don't have window handles..) so I am looking for a similar tool but which does work with MS Access??
Have you considered writting an Automation program to interact with the selected database? If you use the Access Object Model you can gain access to all controls on forms etc.