Validating Microsoft Access Database modifications

Question

Using Testcomplete 8, I am testing an application which creates an access database file as output. I need to validate if a particular&nbsp;record is present in .mdb file or not. I am trying to write a vb script for the same, however I want to parse the database path &amp; record names dynamically. I have created 2 variables which will&nbsp;be updated&nbsp;through an exel file.&nbsp;As I am not a Software engg, I am stuck with the script. Can anyone help with any specific code?

hkosova · Answer

Hi Darshan,What exactly are you having problems with - reading from Excel, variable concatenation, DB validation or something else? Could you post here the script code you have so far?BTW, here are a few links with sample scripts to help you get started:VBScript FundamentalsRead an Excel SpreadsheetReading Data from a Microsoft Access DatabaseFinding Records in a Recordset

Forum Discussion

Validating Microsoft Access Database modifications

Related Content

Handling environments : how to revert unwanted modifications

Modification of test cases by importing from a CSV

Data Validation

TestComplete can't detect elements in Microsoft WebView2 window

Microsoft Excel issue

Recent Discussions

Onscreen Object Selector Slowness

aqObject.CheckProperty() slowness

Problem with generated data table and keyword test

WebView2 support does not work

System checks for Object for every test