Received: from oxmail.ox.ac.uk (oxmail2.ox.ac.uk [163.1.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA49710 for ; Mon, 23 Aug 1999 12:32:30 -0400 (EDT) (envelope-from moray.mcconnachie@computing-services.oxford.ac.uk) Received: from heraldgate1.oucs.ox.ac.uk ([163.1.2.49] helo=frontend1.herald.ox.ac.uk ident=exim) by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1) id 11Ix10-0005y6-00; Mon, 23 Aug 1999 17:32:10 +0100 Received: from moraypc.oucs.ox.ac.uk ([163.1.14.118]) by frontend1.herald.ox.ac.uk with esmtp (Exim 2.02 #1) id 11Ix12-00003d-00; Mon, 23 Aug 1999 17:32:12 +0100 From: Moray McConnachie Date: Mon, 23 Aug 1999 17:28:59 +0100 To: Byron Nikolaidis Subject: Re: [INTERFACES] Access 2000 Cc: pgsql-interfaces@postgresql.org In-Reply-To: <37C173E6.2A1F45F3@solipsys.com> References: <37C173E6.2A1F45F3@solipsys.com> <3.0.5.32.19990823163802.0079f180@199.107.2.1> Message-ID: Priority: NORMAL X-Mailer: Execmail for Win32 Version 5.0.1 Build (55) MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" On Mon, 23 Aug 1999 12:16:38 -0400 Byron Nikolaidis wrote: > > > Michael Doyle wrote: > > > I need help with Access 2000 and PostgreSQL... > > > > I have several databases running on my server (It's a FreeBSD server > > running Postgress 6.4) and Access 95 had no trouble acting as a > > front end to these databases > > > > However, I cannot create new Access 2000 databases to see either new > > or old databases on the server. > > > > Curiously, upgrading the Access 95 databases to Access 2000 lets them > > continue to see the linked tables. > > > > Something strange is going on with Access 2000 and ODBC interfaces. > > Any ideas on how to resolve this ? > > > > Do you see any error messages, either on screen or in any of the logfiles? Michael's problem is basically the same as I posted a few weeks back, and others have contacted me about it since. It appears to leave no error messages, but frankly I've given up and have no longer been looking. Some have said that all 3rd party ODBC drivers have had to be rewritten to co-operate with Access 2000's implementatation of ODBC, which is hardly brilliant! I put in a bug report to Microsoft, but so far no response. ---------------------- Moray.McConnachie@computing-services.oxford.ac.uk