i got no response on the interfaces list -- maybe someone here has
experienced this too??
(msaccess97 / win98, 6.40.0005 odbc driver, postgres 6.4.2, linux mandrake
5.3) i wrote earlier about getting illegal page faults every time i CLOSE a
certain form (it lets me use it just fine!) that is used to ADD RECORDS
only. well, i have created an ultra-basic form linked to the same database
as the crashing form -- no vba underlying it, no fancy formats, nothing
except the fields of the tables dropped in with all default settings. it
crashes too! gotta be in the table or ??. i am not linking the form to a
query, but directly to the table. i have another form linked to the same
table to edit records only -- it limits you to one record only -- works
beautifully. and yet another form showing only limited info from the same
table, but multiple records (never all), works fine too. i do have
declare/fetch on. the table is huge (>45k records, 14,983,168 bytes). if
i try to open the table directly in datasheet view, the odbc driver fails
-- no explanation, but at least no illegal page fault and i get clammed out
of access! i figure that is because of the size of the table. i have
cache set to 100, maxvarchar = 550, maxlongvarchar=15000. in the table i
have one field varchar(300) and another varchar(550). a few "checks"
(state char(2) not null check (state<>' ')). -- ok that's all i know that
would be suspicious. but the edit forms work fine. i also have several
other add-new-record forms set up in the same way that use other tables --
they work fine. any ideas???
here is the win98 message -- these things never do me any good, but maybe
they reveal something!?
MSACCESS caused an invalid page fault in
module PSQLODBC.DLL at 0177:100076a4.
Registers:
EAX=1bfc5000 CS=0177 EIP=100076a4 EFLGS=00010216
EBX=02855d7a SS=017f ESP=0062cbf0 EBP=ffffff99
ECX=00000001 DS=017f ESI=00002328 FS=0eff
EDX=00002328 ES=017f EDI=1bfc2cda GS=0000
Bytes at CS:EIP:
80 38 0d 75 21 8b 7c 24 18 b9 ff ff ff ff 2b c0
Stack dump:
02855c4a 02855d7a ffffff99 00000130 1bfc5000 10006df9 1bfc2cd8 02855d7a
ffffff99 fffffffd 02855660 02855b84 022206e0 00000000 1bfc2cd8 1002000c
also, here is the log file -- it never shows a problem that i can see. . .
thanks in advance for helping! this system is oh so close to being in
use!!!
jt��
begin 600 psqlodbc_4294848641.log
M8V]N;CTT-#@R-C<T-"P@4U%,1')I=F5R0V]N;F5C="@@:6XI/2=$4DE615(]
M>U!O<W1G<F5344Q].T1!5$%"05-%/7-E<G9I8V5W;W)K<SM315)615(]9W)E
M96YM86X[4$]25#TU-#,R.U)%041/3DQ9/3 [4%)/5$]#3TP].T9!2T5/241)
M3D1%6#TP.U-(3U=/241#3TQ534X],#M23U=615)324].24Y'/3 [4TA/5U-9
M4U1%351!0DQ%4STP.T-/3DY3151424Y'4ST[)RP@9D1R:79E<D-O;7!L971I
M;VX],PT*1VQO8F%L($]P=&EO;G,Z(%9E<G-I;VX])S V+C0P+C P,#4G+"!F
M971C:#TQ,# L('-O8VME=#TT,#DV+"!U;FMN;W=N7W-I>F5S/3 L(&UA>%]V
M87)C:&%R7W-I>F4]-34P+"!M87A?;&]N9W9A<F-H87)?<VEZ93TQ-3 P, T*
M(" @(" @(" @(" @(" @(&1I<V%B;&5?;W!T:6UI>F5R/3 L(&MS<6\],2P@
M=6YI<75E7VEN9&5X/3$L('5S95]D96-L87)E9F5T8V@],0T*(" @(" @(" @
M(" @(" @('1E>'1?87-?;&]N9W9A<F-H87(],2P@=6YK;F]W;G-?87-?;&]N
M9W9A<F-H87(],"P@8F]O;'-?87-?8VAA<CTQ#0H@(" @(" @(" @(" @(" @
M97AT<F%?<WES=&%B;&5?<')E9FEX97,])V1D7SLG+"!C;VYN7W-E='1I;F=S
M/2<G#0IC;VYN/30T.#(V-S0T+"!Q=65R>3TG("<-"F-O;FX]-#0X,C8W-#0L
M('%U97)Y/2=S970@1&%T95-T>6QE('1O("=)4T\G)PT*8V]N;CTT-#@R-C<T
M-"P@<75E<GD])W-E="!K<W%O('1O("=/3B<G#0IC;VYN/30T.#(V-S0T+"!Q
M=65R>3TG0D5'24XG#0IC;VYN/30T.#(V-S0T+"!Q=65R>3TG9&5C;&%R92!3
M44Q?0U52,#)!0S,Y,S@@8W5R<V]R(&9O<B!S96QE8W0@;VED(&9R;VT@<&=?
M='EP92!W:&5R92!T>7!N86UE/2=L;R<G#0IC;VYN/30T.#(V-S0T+"!Q=65R
M>3TG9F5T8V@@,3 P(&EN(%-13%]#55(P,D%#,SDS."<-"B @("!;(&9E=&-H
M960@,"!R;W=S(%T-"F-O;FX]-#0X,C8W-#0L('%U97)Y/2=C;&]S92!344Q?
M0U52,#)!0S,Y,S@G#0IC;VYN/30T.#(V-S0T+"!Q=65R>3TG14Y$)PT*8V]N
M;CTT-#@R-C<T-"P@4U%,1')I=F5R0V]N;F5C="AO=70I/2=$4DE615(]>U!O
M<W1G<F5344Q].T1!5$%"05-%/7-E<G9I8V5W;W)K<SM315)615(]9W)E96YM
M86X[4$]25#TU-#,R.U5)1#UK:7)K<&%J=#M05T0].U)%041/3DQ9/3 [4%)/
M5$]#3TP]-BXT.T9!2T5/241)3D1%6#TP.U-(3U=/241#3TQ534X],#M23U=6
M15)324].24Y'/3 [4TA/5U-94U1%351!0DQ%4STP.T-/3DY3151424Y'4STG
M#0IC;VYN/30T.#(V-S0T+"!Q=65R>3TG0D5'24XG#0IC;VYN/30T.#(V-S0T
M+"!Q=65R>3TG9&5C;&%R92!344Q?0U52,#)!0S,Y,S@@8W5R<V]R(&9O<B!3
M14Q%0U0@0V]N9FEG+"!N5F%L=64@1E)/32!-4WES0V]N9B<-"D524D]2(&9R
M;VT@8F%C:V5N9"!D=7)I;F<@<V5N9%]Q=65R>3H@)T524D]2.B @;7-Y<V-O
M;F8Z(%1A8FQE(&1O97,@;F]T(&5X:7-T+B<-"F-O;FX]-#0X,C8W-#0L('%U
M97)Y/2=!0D]25"<-"E-4051%345.5"!%4E)/4CH@9G5N8SU30U]E>&5C=71E
M+"!D97-C/2<G+"!E<G)N=6T],2P@97)R;7-G/2=%<G)O<B!W:&EL92!E>&5C
M=71I;F<@=&AE('%U97)Y)PT*(" @(" @(" @(" @(" @(" M+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2T-"B @(" @(" @(" @(" @(" @:&1B8STT-#@R-C<T-"P@<W1M=#TT
M-#@T,3(W,BP@<F5S=6QT/3 -"B @(" @(" @(" @(" @(" @;6%N=6%L7W)E
M<W5L=#TP+"!P<F5P87)E/3 L(&EN=&5R;F%L/3 -"B @(" @(" @(" @(" @
M(" @8FEN9&EN9W,],"P@8FEN9&EN9W-?86QL;V-A=&5D/3 -"B @(" @(" @
M(" @(" @(" @<&%R86UE=&5R<STP+"!P87)A;65T97)S7V%L;&]C871E9#TP
M#0H@(" @(" @(" @(" @(" @('-T871E;65N=%]T>7!E/3 L('-T871E;65N
M=#TG4T5,14-4($-O;F9I9RP@;E9A;'5E($923TT@35-Y<T-O;F8G#0H@(" @
M(" @(" @(" @(" @('-T;71?=VET:%]P87)A;7,])V1E8VQA<F4@4U%,7T-5
M4C R04,S.3,X(&-U<G-O<B!F;W(@4T5,14-4($-O;F9I9RP@;E9A;'5E($92
M3TT@35-Y<T-O;F8G#0H@(" @(" @(" @(" @(" @(&1A=&%?871?97AE8STM
M,2P@8W5R<F5N=%]E>&5C7W!A<F%M/2TQ+"!P=71?9&%T83TP#0H@(" @(" @
M(" @(" @(" @(&-U<G)4=7!L93TM,2P@8W5R<F5N=%]C;VP]+3$L(&QO8FI?
M9F0]+3$-"B @(" @(" @(" @(" @(" @;6%X4F]W<STP+"!R;W=S971?<VEZ
M93TQ+"!K97ES971?<VEZ93TP+"!C=7)S;W)?='EP93TP+"!S8W)O;&Q?8V]N
M8W5R<F5N8WD],0T*(" @(" @(" @(" @(" @("!C=7)S;W)?;F%M93TG4U%,
M7T-54C R04,S.3,X)PT*(" @(" @(" @(" @(" @(" M+2TM+2TM+2TM+2TM
M+2TM45)E<W5L="!);F9O("TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2T-"D-/3DX@15)23U(Z(&9U;F,]4T-?97AE8W5T92P@9&5S8STG)RP@97)R
M;G5M/3$Q,"P@97)R;7-G/2=%4E)/4CH@(&US>7-C;VYF.B!486)L92!D;V5S
M(&YO="!E>&ES="XG#0H@(" @(" @(" @(" M+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T-"B @
M(" @(" @(" @(&AE;G8]-#4X-S4S,S(L(&-O;FX]-#0X,C8W-#0L('-T871U
M<STQ+"!N=6U?<W1M=',],38-"B @(" @(" @(" @('-O8VL]-#4X-S4S-#@L
M('-T;71S/30U.#<U,S@X+"!L;V)J7W1Y<&4]+3DY.0T*(" @(" @(" @(" @
M+2TM+2TM+2TM+2TM+2TM+2!3;V-K970@26YF;R M+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM#0H@(" @(" @(" @("!S;V-K970],C(T+"!R979E
M<G-E/3 L(&5R<F]R;G5M8F5R/3 L(&5R<F]R;7-G/2<H;G5L;"DG#0H@(" @
M(" @(" @("!B=69F97)?:6X]-#0X,S,P-S(L(&)U9F9E<E]O=70]-#0X,S<Q
M-S(-"B @(" @(" @(" @(&)U9F9E<E]F:6QL961?:6X],RP@8G5F9F5R7V9I
M;&QE9%]O=70],"P@8G5F9F5R7W)E861?:6X],@T*8V]N;CTT-#@R-C<T-"P@
M<75E<GD])T)%1TE.)PT*8V]N;CTT-#@R-C<T-"P@<75E<GD])V1E8VQA<F4@
M4U%,7T-54C R04,S.3,X(&-U<G-O<B!F;W(@4T5,14-4(")P;6%S=&5R(BXB
M<&%R=&YU;2(@1E)/32 B<&UA<W1E<B(@)PT*8V]N;CTT-#@R-C<T-"P@<75E
M<GD])V9E=&-H(#$P,"!I;B!344Q?0U52,#)!0S,Y,S@G#0H@(" @6R!F971C
M:&5D(#$P,"!R;W=S(%T-"F-O;FX]-#0X,C8W-#0L('%U97)Y/2=F971C:" Q
M,# @:6X@4U%,7T-54C R04,S.3,X)PT*(" @(%L@9F5T8VAE9" Q,# @<F]W
M<R!=#0IC;VYN/30T.3$Q-C$R+"!344Q$<FEV97)#;VYN96-T*"!I;BD])T12
M259%4CU[4&]S=&=R95-13'T[54E$/6MI<FMP86IT.U!71#T[1$%404)!4T4]
M<V5R=FEC97=O<FMS.U-%4E9%4CUG<F5E;FUA;CM03U)4/34T,S([4D5!1$].
M3%D],#M04D]43T-/3#T[1D%+14])1$E.1$58/3 [4TA/5T])1$-/3%5-3CTP
M.U)/5U9%4E-)3TY)3D<],#M32$]74UE35$5-5$%"3$53/3 [0T].3E-%5%1)
M3D=3/3LG+"!F1')I=F5R0V]M<&QE=&EO;CTP#0I';&]B86P@3W!T:6]N<SH@
M5F5R<VEO;CTG,#8N-# N,# P-2<L(&9E=&-H/3$P,"P@<V]C:V5T/30P.38L
M('5N:VYO=VY?<VEZ97,],"P@;6%X7W9A<F-H87)?<VEZ93TU-3 L(&UA>%]L
M;VYG=F%R8VAA<E]S:7IE/3$U,# P#0H@(" @(" @(" @(" @(" @9&ES86)L
M95]O<'1I;6EZ97(],"P@:W-Q;STQ+"!U;FEQ=65?:6YD97@],2P@=7-E7V1E
M8VQA<F5F971C:#TQ#0H@(" @(" @(" @(" @(" @=&5X=%]A<U]L;VYG=F%R
M8VAA<CTQ+"!U;FMN;W=N<U]A<U]L;VYG=F%R8VAA<CTP+"!B;V]L<U]A<U]C
M:&%R/3$-"B @(" @(" @(" @(" @("!E>'1R85]S>7-T86)L95]P<F5F:7AE
M<STG9&1?.R<L(&-O;FY?<V5T=&EN9W,])R<-"F-O;FX]-#0Y,3$V,3(L('%U
M97)Y/2<@)PT*8V]N;CTT-#DQ,38Q,BP@<75E<GD])W-E="!$871E4W1Y;&4@
M=&\@)TE33R<G#0IC;VYN/30T.3$Q-C$R+"!Q=65R>3TG<V5T(&MS<6\@=&\@
M)T].)R<-"F-O;FX]-#0Y,3$V,3(L('%U97)Y/2="14=)3B<-"F-O;FX]-#0Y
M,3$V,3(L('%U97)Y/2=D96-L87)E(%-13%]#55(P,D%$.#4R."!C=7)S;W(@
M9F]R('-E;&5C="!O:60@9G)O;2!P9U]T>7!E('=H97)E('1Y<&YA;64])VQO
M)R<-"F-O;FX]-#0Y,3$V,3(L('%U97)Y/2=F971C:" Q,# @:6X@4U%,7T-5
M4C R040X-3(X)PT*(" @(%L@9F5T8VAE9" P(')O=W,@70T*8V]N;CTT-#DQ
M,38Q,BP@<75E<GD])V-L;W-E(%-13%]#55(P,D%$.#4R."<-"F-O;FX]-#0Y
M,3$V,3(L('%U97)Y/2=%3D0G#0IC;VYN/30T.3$Q-C$R+"!344Q$<FEV97)#
M;VYN96-T*&]U="D])T12259%4CU[4&]S=&=R95-13'T[1$%404)!4T4]<V5R
M=FEC97=O<FMS.U-%4E9%4CUG<F5E;FUA;CM03U)4/34T,S([54E$/6MI<FMP
M86IT.U!71#T[4D5!1$].3%D],#M04D]43T-/3#TV+C0[1D%+14])1$E.1$58
M/3 [4TA/5T])1$-/3%5-3CTP.U)/5U9%4E-)3TY)3D<],#M32$]74UE35$5-
M5$%"3$53/3 [0T].3E-%5%1)3D=3/2<-"F-O;FX]-#0Y,3$V,3(L('%U97)Y
M/2="14=)3B<-"F-O;FX]-#0Y,3$V,3(L('%U97)Y/2=D96-L87)E(%-13%]#
M55(P,D%$.#4R."!C=7)S;W(@9F]R(%-%3$5#5" B<&%R=&YU;2(L(G!D97-C
M(BPB<'5N:71C;W-T(BPB<'5N:71P<F,B+")P;F]T97,B+")V;G5M(BPB:6YA
M8W0B("!&4D]-(")P;6%S=&5R(B @5TA%4D4@(G!A<G1N=6TB(#T@)U!44# T
M-R<@3U(@(G!A<G1N=6TB(#T@)U!44# T."<@3U(@(G!A<G1N=6TB(#T@)U!5
M,# P,2<@3U(@(G!A<G1N=6TB(#T@)U!7,# S,"<@3U(@(G!A<G1N=6TB(#T@
M)U!7,# S,2<@3U(@(G!A<G1N=6TB(#T@)U!7,# S,B<@3U(@(G!A<G1N=6TB
M(#T@)U!7,# S,R<@3U(@(G!A<G1N=6TB(#T@)U!7,# S-"<@3U(@(G!A<G1N
M=6TB(#T@)U!7,# S-2<@3U(@(G!A<G1N=6TB(#T@)U!7,# S-B<G#0IC;VYN
M/30T.3$Q-C$R+"!Q=65R>3TG9F5T8V@@,3 P(&EN(%-13%]#55(P,D%$.#4R
M."<-"B @("!;(&9E=&-H960@,3 @<F]W<R!=#0IC;VYN/30T.3$Q-C$R+"!Q
M=65R>3TG8VQO<V4@4U%,7T-54C R040X-3(X)PT*8V]N;CTT-#DQ,38Q,BP@
M<75E<GD])T5.1"<-"F-O;FX]-#0Y,3$V,3(L('%U97)Y/2="14=)3B<-"F-O
M;FX]-#0Y,3$V,3(L('%U97)Y/2=D96-L87)E(%-13%]#55(P,D%$.#4R."!C
M=7)S;W(@9F]R(%-%3$5#5" B<&%R=&YU;2(L(G!D97-C(BPB<'5N:71C;W-T
M(BPB<'5N:71P<F,B+")P;F]T97,B+")V;G5M(BPB:6YA8W0B("!&4D]-(")P
M;6%S=&5R(B @5TA%4D4@(G!A<G1N=6TB(#T@)U!7,# S-R<@3U(@(G!A<G1N
M=6TB(#T@)U!7,# S."<@3U(@(G!A<G1N=6TB(#T@)U!7,# S.2<@3U(@(G!A
M<G1N=6TB(#T@)U!7,# T,"<@3U(@(G!A<G1N=6TB(#T@)U!7,# T,2<@3U(@
M(G!A<G1N=6TB(#T@)U!7,# T,B<@3U(@(G!A<G1N=6TB(#T@)U!7,# T,R<@
M3U(@(G!A<G1N=6TB(#T@)U!7,# T-"<@3U(@(G!A<G1N=6TB(#T@)U!7,# T
M-2<@3U(@(G!A<G1N=6TB(#T@)U!7,# T-B<G#0IC;VYN/30T.3$Q-C$R+"!Q
M=65R>3TG9F5T8V@@,3 P(&EN(%-13%]#55(P,D%$.#4R."<-"B @("!;(&9E
M=&-H960@,3 @<F]W<R!=#0IC;VYN/30T.3$Q-C$R+"!Q=65R>3TG8VQO<V4@
M4U%,7T-54C R040X-3(X)PT*8V]N;CTT-#DQ,38Q,BP@<75E<GD])T5.1"<-
M"F-O;FX]-#0Y,3$V,3(L('%U97)Y/2="14=)3B<-"F-O;FX]-#0Y,3$V,3(L
M('%U97)Y/2=D96-L87)E(%-13%]#55(P,D%$.#4R."!C=7)S;W(@9F]R(%-%
M3$5#5" B<&%R=&YU;2(L(G!D97-C(BPB<'5N:71C;W-T(BPB<'5N:71P<F,B
M+")P;F]T97,B+")V;G5M(BPB:6YA8W0B("!&4D]-(")P;6%S=&5R(B @5TA%
M4D4@(G!A<G1N=6TB(#T@)U!7,# T-R<@3U(@(G!A<G1N=6TB(#T@)U!7,# T
M."<@3U(@(G!A<G1N=6TB(#T@)U!7,# T.2<@3U(@(G!A<G1N=6TB(#T@)U!7
M,# U,"<@3U(@(G!A<G1N=6TB(#T@)U!7,# U,2<@3U(@(G!A<G1N=6TB(#T@
M)U!7,# U,B<@3U(@(G!A<G1N=6TB(#T@)U!7,# U,R<@3U(@(G!A<G1N=6TB
M(#T@)U!7,# U-"<@3U(@(G!A<G1N=6TB(#T@)U!7,# U-2<@3U(@(G!A<G1N
M=6TB(#T@)U!7,# U-B<G#0IC;VYN/30T.3$Q-C$R+"!Q=65R>3TG9F5T8V@@
M,3 P(&EN(%-13%]#55(P,D%$.#4R."<-"B @("!;(&9E=&-H960@,3 @<F]W
M<R!=#0IC;VYN/30T.3$Q-C$R+"!Q=65R>3TG8VQO<V4@4U%,7T-54C R040X
M-3(X)PT*8V]N;CTT-#DQ,38Q,BP@<75E<GD])T5.1"<-"F-O;FX]-#0X,C8W
M-#0L('%U97)Y/2=C;&]S92!344Q?0U52,#)!0S,Y,S@G#0IC;VYN/30T.#(V
M-S0T+"!Q=65R>3TG14Y$)PT*8V]N;CTT-#DQ,38Q,BP@4U%,1&ES8V]N;F5C
A= T*8V]N;CTT-#@R-C<T-"P@4U%,1&ES8V]N;F5C= T*
`
end
