illegal page faults. . .
От | JT Kirkpatrick |
---|---|
Тема | illegal page faults. . . |
Дата | |
Msg-id | 01BEA84D.5A63F140.jt-kirkpatrick@mpsllc.com обсуждение исходный текст |
Список | 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
В списке pgsql-interfaces по дате отправления: