Re: Access Crashes with CONTAINS in ServerFilter

From: Paul Smith (paulgcsmith_at_hotmail.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 08:46:05 -0600

You are correct in understanding the problem. Let me answer your questions
and add some additional information which has been learned since the
original post.

1. Here is the information from the event viewer:
Event Type: Error
Event Source: Microsoft Office 10
Event Category: None
Event ID: 1000
Date: 8/26/2004
Time: 7:23:39 AM
User: N/A
Computer: JRSMITH129716

Description:
Faulting application msaccess.exe, version 10.0.6501.0, faulting module
vbe6.dll, version 6.4.99.69, fault address 0x000a40ef.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6d 73 61 ure msa
0018: 63 63 65 73 73 2e 65 78 ccess.ex
0020: 65 20 31 30 2e 30 2e 36 e 10.0.6
0028: 35 30 31 2e 30 20 69 6e 501.0 in
0030: 20 76 62 65 36 2e 64 6c vbe6.dl
0038: 6c 20 36 2e 34 2e 39 39 l 6.4.99
0040: 2e 36 39 20 61 74 20 6f .69 at o
0048: 66 66 73 65 74 20 30 30 ffset 00
0050: 30 61 34 30 65 66 0d 0a 0a40ef..

2. Running the SQL in Query Analyzer produces correct results.

3. Access erases a WHERE clause contining the CONTAINS predicate or ignores
it when executed -- both behaviors have been observed.

4. Service Pack 3 is installed for Office, and SQL Server 2000 has service
pack 3 installed as well.

Additional Infomation:
A trace using SQL Profiler revealed that Access is producing a string of SQL
SELECT statements (54 to be exact) which are in the form SELECT * FROM
"dbo"."tablename" WHERE (CONTAINS (*, 'string')).
With each successive call by Access, an additional set of parentheses is
added around the CONTAINS predicate.

We sometimes receive an error message saying "Invalid SQL statement. Check
the Server Filter on the form record source." (error number 30025) instead
of a complete crash. There is no apparent rhyme or reason to whether we get
the crash or the kinder, gentler error message.

""Mingqing Cheng [MSFT]"" <v-mingqc@online.microsoft.com> wrote in message
news:3tlWaVziEHA.1924@cpmsftngxa10.phx.gbl...
> Hi,
>
> From your descriptions, I understood that your Access crashes after you
> tried to dynamically compose the WHERE cluase. Have I understood you? If
> there is anything I misunderstood, please feel free to let me know.
>
> First of all, please understand that this kind of issue might be very hard
> for troubleshooting, we may take a while resolving it. If it is an urgent
> one, you can contact Microsoft Product Support directly to discuss
> additional support options you may have available, by contacting us at
> 1-(800)936-5800 or by choosing one of the options listed at
> http://support.microsoft.com/default.aspx?scid=sz;en-us;top.
>
> Secondly, please help me find the find the information below
> 1. When Access crashes, you might find some error log in Event View, can
> you paste all of them here? I believe they are very helpful.
>
> 2. If you run the whole SELECT clause in Query Analyzer, will it get back
> the result you want?
>
> 3. If you make a static SELECT clause in your ADP project, will it get
back
> the correct result?
>
> Last but not the least, have you updated to the lastest service pack of
> Access 2002? You could get them in the following links
>
> Issues that are fixed in Access 2002 by Office XP Service Pack 3
> http://support.microsoft.com/default.aspx?scid=kb;en-us;836030
>
> The following documents describes two scenario that may crash Access
>
> ACC2002: Access Crashes When You Sort a Table That Has a Subdata***
> http://support.microsoft.com/?id=295251
>
> You may receive the "Microsoft Access has encountered a problem and needs
> to close" error message when you try to create a new database or to open
an
> existing database in Access 2002
> http://support.microsoft.com/?id=873266
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
>
> Sincerely yours,
>
> Mingqing Cheng
> Microsoft Developer Community Support
> ---------------------------------------------------------------
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>
>