Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA12975 for ; Tue, 9 Jun 1998 09:50:11 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id JAA06750 for pgsql-interfaces@PostgreSQL.org; Tue, 9 Jun 1998 09:20:14 -0400 (EDT) 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 AA32583; Tue, 9 Jun 1998 09:17:23 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA39274; Tue, 9 Jun 1998 09:17:23 -0400 Message-Id: <357D359D.CFDEF5@insightdist.com> Date: Tue, 09 Jun 1998 09:16:13 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: "Jose' Soares Da Silva" Cc: interfaces postgres Subject: Re: M$-Access'97 and TIMESTAMPs References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jose' Soares Da Silva wrote: > Hi, all! > > I created a table with a TIMESTAMP data type to use with M$-Access, because > Access uses such field to control concurrent access on records. > But I have a problem M$-Access doesn't recognize a TIMESTAMP type, it see > such fields as "text" instead of "date/time". > Is there a way to make Access recognize TIMESTAMPs ? > Thanks, Jose' I could add TimeStamp as a supported data type of the odbc driver. Currently, 'abstime' is supported but not 'timestamp'. Byron