illegal page faults. . .

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org>
Subject: illegal page faults. . .
Date: 1999-05-27 18:29:36
Message-ID: 01BEA84D.5A63F140.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

(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. any ideas???

jt

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-05-27 20:44:47 Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow
Previous Message Alex Turner 1999-05-27 17:49:06 Wierd error when creating a table...