Re[2]: [INTERFACES] Access 2000

I happened to mention a similar occurence to our 'local' Microsoft     (hereinafter referred to as M$)
representativeat a seminar yesterday     (B.O.) and his take on the issue is not ODBC, rather the culprit is     due to
theinternal rewrite that's gone into M$ Access 2000.  His     reply went something like this:        M$ Access 2000 is
nowunicode-aware and requires MDAC 2.1 or higher -     unlike M$ Access 97, the only M$ Office product not unicoded in
the97     release.  Because of the unicode (which is a two-byte character     encoding scheme - see
http://msdn.microsoft.com/library/officedev/off2000/defunicode.htmfor     a definition) implementation, older Access
databasesmust be     'imported' and updated - BUT this updating process does not update the     ODBC driver to
recognizethe fact that the linked tables are not     unicode-aware (i.e. a postgreSQL database) and therefore data in
those    tables can't be modified since there is no provision for this scenario     in M$ sourcecode.        Based on
thisresponse, I assume M$ is aware of the issue.  At least     the rep seems to be.  It would be nice to know if there
issomething     to come of this and similar issues concerning updating and moving     forward.        Humbly,
Laszlo


______________________________ Reply Separator _________________________________
Subject: Re: [INTERFACES] Access 2000 
Author:  Robert Hiltibidal <rob@y2k.state.il.us>  at INTERNET
Date:    8/23/99 2:29 PM

    
So... all problems are solved with Office 2000?     
-Rob    
>X-POP3-Rcpt: rob@y2k
>From: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk> 
>Date: Mon, 23 Aug 1999 17:28:59 +0100
>To: Byron Nikolaidis <byronn@solipsys.com> 
>Subject: Re: [INTERFACES] Access 2000
>Cc: pgsql-interfaces@postgreSQL.org
>X-Mailer: Execmail for Win32 Version 5.0.1 Build (55) 
>Sender: owner-pgsql-interfaces@postgreSQL.org
>
>On Mon, 23 Aug 1999 12:16:38 -0400 Byron Nikolaidis 
><byronn@solipsys.com> 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 
>
>
>************
>
>