G
Guest
Dear All,
I have created a webpage which will access a Access MDB file. However,
there are some problem when I access the MDB file.
I found that the problem is from SQL statement of OLEDBCommand. For example:
if I use "Select * from Location", then the ASP.NET applicant can run
normally; but when I use "Select LocationID from Location", then an exception
is caught. But the exception message is : "Unknow". So I don't know how to
fix this problem.
Could you tell me what is the problem and how to fix it ?
Thanks.
P.S. I use Visual Web Developer 2005 to develop this ASP.NET application.
The MDB file is created by using Access 2003
I have created a webpage which will access a Access MDB file. However,
there are some problem when I access the MDB file.
I found that the problem is from SQL statement of OLEDBCommand. For example:
if I use "Select * from Location", then the ASP.NET applicant can run
normally; but when I use "Select LocationID from Location", then an exception
is caught. But the exception message is : "Unknow". So I don't know how to
fix this problem.
Could you tell me what is the problem and how to fix it ?
Thanks.
P.S. I use Visual Web Developer 2005 to develop this ASP.NET application.
The MDB file is created by using Access 2003