Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Testing access database
#3
Not Solved
HI S,

Try the this code.
Code:
Set oAccess= CreateObject("ADODB.Connection")
oAccess.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=H:\qtp\test.accdb"
If oAccess.State = 1 Then
    Msgbox "Pass"&vbcrlf&"Database Connection"&vbcrlf&"Database Connection is Open"
Else
   Msgbox "Fail" &vbcrlf&"Database Connection" &vbcrlf&"Database Connection is not Open"
End If
Thanks,
SUpputuri
Reply


Messages In This Thread
Testing access database - by shipu - 01-30-2014, 01:17 AM
RE: Testing access database - by shipu - 01-30-2014, 04:35 AM
RE: Testing access database - by supputuri - 01-30-2014, 10:19 AM
RE: Testing access database - by shipu - 01-30-2014, 08:05 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Issue in database testing excellentpawan 0 1,532 03-24-2015, 01:10 PM
Last Post: excellentpawan

Forum Jump:


Users browsing this thread: 1 Guest(s)