Access DB
-
Hi All, I want to select a records from access database depends on where clause as the following : select ID as found from TransLog where UserID='61' and TransType='0' and TransTime =#28-04-14 08:46:46# but the error occurred when I use the TransTime =#28-04-14 08:46:46# the error is:: IErrorInfo.GetDescription failed with E_FAIL(0x80004005) Please help me ASAP. Thank you very much
-
Hi All, I want to select a records from access database depends on where clause as the following : select ID as found from TransLog where UserID='61' and TransType='0' and TransTime =#28-04-14 08:46:46# but the error occurred when I use the TransTime =#28-04-14 08:46:46# the error is:: IErrorInfo.GetDescription failed with E_FAIL(0x80004005) Please help me ASAP. Thank you very much
Where did you enter that query? In an MS Access GUI? In a .Net application which connects to your database? Also: is that the correct DateTime format of that user?
-
Hi All, I want to select a records from access database depends on where clause as the following : select ID as found from TransLog where UserID='61' and TransType='0' and TransTime =#28-04-14 08:46:46# but the error occurred when I use the TransTime =#28-04-14 08:46:46# the error is:: IErrorInfo.GetDescription failed with E_FAIL(0x80004005) Please help me ASAP. Thank you very much
If you User id is int then no need to put single query. And in TransTime put single quote instead of #
select ID as found from TransLog where UserID=61 and TransType='0' and TransTime ='28-04-14 08:46:46'
Sankarsan Parida