"Unspecified error" message for one field only

  • Thread starter Thread starter Wong Chin Shin
  • Start date Start date
W

Wong Chin Shin

Hi all,

I have been hitting on this error:

Error Type:
(0x80004005)
Unspecified error

in my ASP script whenever I make a query against an Access database like
this: "select * from Jobs where (Position LIKE '%Manager%')".

Facts:
1) Connection to the database is done using Jet 4.0
2) Position is a field of type Text set to 255 characters.
3) This error does not happen when I submit similar queries to another
field in the SAME table of the same type.

Is it because "Position" is a reserved keyword in Access?

Thank you for any help rendered!!
Wong
 
Since the error appears to be a scripting error, the folks in the ASP
newsgroup could probably help you better. However, I'll give it a try. In
your "LIKE" statement you are using "%" as the wild card character. This is
correct for SQL, but the wild card character for Jet is "*". However, I
don't know if ASP needs the "%" and it translates it to Jet for you or not.
Also, Position is a Property of ADO. To test and see if that is causing a
problem, try enclosing it in brackets [Position].
 
I dont have any field in my database like "Position" .
I am using Jet 4.0 ...
So, what is the solution ??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access cant change the data type ; there is not enough disk space or memory. 4
Error 0xC00D3E8E: The property is read only. One way to fix. 1
Reserved error (-1524); there is no message for this error. 3
Memo type field size 7
Unspecified Error - 2
Keep getting error 3001 message in access 2003 db, in vbsearch? 1
[OleDbException (0x80004005): Unspecified error] 7
Memo field is automatically changing to text field in count query 3

Back
Top