Access crashes for specific data records on XP

[hayo]

I have an Access97 frontend for an Oracle database, which runs without problems on NT4.

I installed Access97 on an XP-machine, and got the mdb frontend running on XP.

Now I experience very strange errors, but only on XP:
For some entries in the database (I found 4 up to now, there may be (much??) more), which generate Access crashes on retrieval: if these records are in the result set of some database search, and if these records are first(!) in the result set, then Access97 terminates with msaccess.exe-violation error (sqora32.dll).

Same behavior if I convert to Access2002.

The search is performed by an "DoCmd.ApplyFilter" command.

Has anybody seen something similar somewhere ?

Hayo

 

[XTnCIS]

It's been a while since you posted your question, but I thought I'd put in my 2 cents worth and maybe you could let me know how things have been going for you.

I am attempting to create a recordset from Oracle and assign that recordset to a combobox in Access. I'm using the Microsoft ODBC for Oracle driver (MSDASQL.dll) and run into a problem with running a select statement that unions tables. When number fields are pulled into Access as part of the Union statement they display as if they were non-keyboard charatures (lines and dots... rather than numbers).

If I display the rs.fields(0).value property in say a msgbox, it displays correctly, but when I assign the rs to a combobox, the numbers display as ... well they look like a different keyboard set?

This only happens whith number fields (not varchar2 or date). I'm attempting to use a different ODBC driver and have found that SQORA32.dll is the dll for the Oracle ODBC driver.

You might try switching your ODBC driver if you are still having trouble.

For me, I'm getting a 'Class is unregistered' error when I try to make my connection with the SQORA32.dll. I'm sure I'll work that out, but if you have any pointers or code examples, I'd appreciate any infomration.

Thanks.