Re: RecordSet fails if a field is null ! - unspecified error '80004005'

Troubled User wrote:
I'll assume
that
you know more then me about that then I do, so ill just add that in
anyway.'


Well, if you're going to get snotty about it ...

Apologies.

Oh, geez. This was my bad. I definitely misinterpreted what you wrote. If
anyone needs to apologize, it's me. So, I apologize.


<snip>

yikes

OK, I asked you what the datatype of the origin field was and you did not
understand the question. So I will ask again: what type of data is stored in
origin? Text or numbers?

Actually, it doesn't matter. There is nothing about a null being returned
that should cause an error when you open a recordset.

Are you sure it's the rs.open line? Have you temporarily, for debugging
purposes, put a response.end statement on the next line after the open
statement to see if the error still occur?

If you are sure about the open statement raising the error, then I have to
start grasping at straws. Could your database be corrupt? There are database
utilities in Access that you can use to compact and repair your database.
Give that a try.

Maybe something is wrong with your Jet components. Go to microsoft.com and
search for the latest Jet 4.0 service pack (you should probably ask in an
Access group for pointers to that).

Are you using the Jet OLE DB provider in your connection string? Or the ODBC
driver? Switch to the one you are not using to see if that makes a
difference.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... release one for Vista. ... Jet is not 64 bits compatible, thus a 64 bits application can't ... use Jet provider to connect to a MS Access database ... This email account is my spam trap so ...
    (microsoft.public.data.ado)
  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... Yes - although that WS2003 patch does provide some hope that they will release one for Vista. ... Jet is not 64 bits compatible, thus a 64 bits application can't ... use Jet provider to connect to a MS Access database ... This email account is my spam trap so ...
    (microsoft.public.data.ado)
  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... data from your Jet database and putting it into a database that can be ... Access Database under Windows Vista 64 bits. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: ACCESS and ASP
    ... you should be aware that earlier versions of Jet required a "*" ... > Please post ASP questions in ASP groups, ... > When you delete a record from a database, ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Access Printing
    ... remember to click on selected record for it to print only that page ... or it will print the whole database. ... You might want to ask this in an Access group. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)