Re: Re: ODBC Interface questions

RE: [GENERAL] Re: ODBC Interface questionsThis presumes that the AddIn is installed.
----- Original Message -----
From: Michael Ansley
To: 'Moray McConnachie' ; Michael Black
Cc: pgsql-general(at)postgreSQL(dot)org
Sent: Tuesday, April 04, 2000 4:46 AM
Subject: RE: [GENERAL] Re: ODBC Interface questions

Doesn't the linked table manager add-in refresh the tables 'nicely'?

MikeA

>> -----Original Message-----
>> From: Moray McConnachie
>> [mailto:moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk]
>> Sent: 03 April 2000 20:11
>> To: Michael Black
>> Cc: pgsql-general(at)postgreSQL(dot)org
>> Subject: Re: [GENERAL] Re: ODBC Interface questions
>>
>>
>>
>>
>> > ----------
>> > From: Moray
>> McConnachie[SMTP:MORAY(dot)MCCONNACHIE(at)COMPUTING-SERVICES(dot)OXFORD(dot)AC(dot)UK]
>> > Sent: Monday, April 03, 2000 9:10:30 PM
>> > To: Michael Black
>> > Cc: pgsql-general(at)postgreSQL(dot)org
>> > Subject: Re: [GENERAL] Re: ODBC Interface questions
>> > Auto forwarded by a Rule
>> >
>> >
>> ----- Original Message -----
>> From: Michael Black <mblack(at)distcompsols(dot)com>
>> To: <pgsql-questions(at)postgresql(dot)org>
>> Sent: Sunday, April 02, 2000 9:17 PM
>> Subject: [GENERAL] Re: ODBC Interface questions
>>
>>
>> > I am using the Insight ODBC driver version 6.40.0009 on
>> a Win98 box and
>> > Access 97.
>> > I set it up as a System DNS. Originally, I linked all
>> the tables with the
>> > Read Only
>> > option checked. I have since changed this to
>> un-checked. However, the
>> > tables were still RO. So I dropped all the links and
>> re-linked them.
>> > I am now able to add or update records in the database.
>> >
>>
>> This is true for all versions of Access, and indeed if you
>> change the port
>> or the host of your pgsql database, you will similarly
>> need to drop and
>> relink all tables.
>>
>> If you turn on in Access the option to view all system
>> tables, and explore a
>> bit, you will see that the specific ODBC string generated
>> from the DSN is
>> stored with the table definition.
>>
>> I believe, though I haven't tried it, that it's possible
>> to rewrite all
>> these tabledefs just to refer only to the DSN, and omit
>> any specific
>> references. Going to be slower, though....
>>
>> Yours,
>> Moray
>>