Hi All,
I am facing one error while tryin to open a table in access from VB
The error is as follows
Run-time error '-2147467259(80004005)':
Method 'Open' of object '_Recordset' Failed
Below is the code for the same
CODE
rsAdd.Open strQuery, g_objData.m_dbConn, adOpenStatic, adLockOptimistic
where
strQuery = strQuery = "Select top 1 * from Connection order by SubscriberCode desc"
g_objData.m_dbConn = Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\Neal Gabriel\Others\Asianet\Database\Master.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password=samtron;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
-------------------------------------------------------------------------------------------
What can be cause of this. I 've been using the same code for the past 3 years; This is the first time i am experiencing an error like this. Please lemme knw a solution for the same. Thanks in advance