Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA32121 for ; Fri, 26 Feb 1999 09:30:56 -0500 (EST) (envelope-from byronn@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id JAA14452 for pgsql-interfaces@postgresql.org; Fri, 26 Feb 1999 09:30:52 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA19306; Fri, 26 Feb 1999 09:03:45 -0500 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA30804; Fri, 26 Feb 1999 09:03:45 -0500 Message-Id: <36D6AA21.970B847D@insightdist.com> Date: Fri, 26 Feb 1999 09:05:21 -0500 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Michael Davis Cc: "'pgsql-interfaces@postgresql.org'" Subject: Re: Access problems References: <93C04F1F5173D211A27900105AA8FCFC145205@lambic.prevuenet.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Michael Davis wrote: > The sql.log file is over 5M. There are no references to foreign keys > anywhere in the log file. I noticed the following: > Orders 138:118 ENTER SQLExecDirect > HSTMT 0x09072230 > UCHAR * 0x040f10f0 [ -3] "SELECT > Config, nValue FROM MSysConf\ 0" > SDWORD -3 > This failed because my Postgres database does not have this table. Any idea > what MsysConf, what it contains, or how to create it? Could this have > anything to do with my Access subform problem? > No. This is a normal Access warning. It is looking for a configuration file for the Jet database engine. It is optional. But it is interesting that there are no references to "SQLForeignKeys". What's up with that? Are there any references to SQLPrimaryKeys? I don't understand -- if it doesn't call SQLForeignKeys, how else would it find out about this information? Byron