| || |
I am using QTP 9.1 ,QC 9.2 and MS-Access 2003
In our project we are using the MS-Access 2003, where multiple tester will be reading and/or writing to the database concurrently.
we are getting the following Error :
The database has been placed in a state by user '' on machine '' that prevents it from being opened or locked. Function file: [QualityCenter] Subject\Project.vbs Line (936): " Con.Open AccResLocation".
while executing the below code:
3)Con.Provider = "Microsoft.Jet.OLEDB.4.0"
we are not able to figure out what actually is the problem
Re: Database Error
I'm Not sure if this works with Access but I know that in SQL Server there is a way to read the database with (NOLOCK) command which will not lock the database.
you can also put a try catch kind of thing and continue in the loop until you get the database to be locked for writing.