How to test MSACCESS VBA form based application using Visual Studio 2010 test project

Question

Hi All 

i have a msaccess application which has number of forms and modules with functions i need to do functional and ui testing along with load test. i was suggested to perform testing with visual studio 2010 test project framework.

i am bit confused on how to proceed because when i open the accessclient forms it finds the buttons on the form trough coordinates and it stops the test/hover glass the test script in between please guide me how to test msaccess mdb application with forms and code behind using microsoft visual studio 2010 test project.

thanks 

steave

Answer 1

Hi steave,

Thank you for posting in the MSDN forum.

Do you mean that you want to use the web performance test?

Since I’m not an expert about the msaccess mdb application, so I might not have the correct detailed answer you need, but I might lead you into the right direction to solve your problem.

1. The Web tests work at the protocol layer by issuing HTTP requests. They are used to test the functionality of Web applications and to test Web applications under load. Web tests are used both in performance tests and stress tests.
2. The coded UI tests provide functional testing of the user interface and validation of user interface controls. We also need to make sure that whether the coded UI test supported it, see “Supported Configurations and Platforms for Coded UI Tests and Action Recordings”.

In addition, if you want to test a class method, we often use the unit test. So I mean that we should check which kinds of tests we want to use and whether this test supports your APP.

Reference:

http://msdn.microsoft.com/en-us/library/ms182514(v=VS.90).aspx

http://msdn.microsoft.com/en-us/library/dd286726.aspx

Best Regards,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi steave,

I mark the answer, please check it. If you need further assistance, please feel free to let us know.

Have a nice day,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi Jack,

First of all thank you for your precious reply

i have been able to do test project with visual studio 2010 test project but it allows me do coded UI test only i need to do some advanced level of asserts and comparison trough winmerge please do let me know if i am following the correct steps or missing something.

i have also been told that in visual studio 2011 there are some more features for testing the applications please confirm me on that as well.

Thanks

---------

Steave