Yes, that's true, but I thought that it was installed by default, so it should be there in most cases, and if not, it shouldn't be difficult to get it.
MikeA
This presumes that the AddIn is installed.
----- Original Message -----
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.mcconnachie@computing-services.oxford.ac.uk]
>> Sent: 03 April 2000 20:11
>> To: Michael Black
>> Cc: pgsql-general@postgreSQL.org
>> Subject: Re: [GENERAL] Re: ODBC Interface questions
>>
>>
>>
>>
>> > ----------
>> > From: Moray
>> McConnachie[SMTP:MORAY.MCCONNACHIE@COMPUTING-SERVICES.OXFORD.AC.UK]
>> > Sent: Monday, April 03, 2000 9:10:30 PM
>> > To: Michael Black
>> > Cc: pgsql-general@postgreSQL.org
>> > Subject: Re: [GENERAL] Re: ODBC Interface questions
>> > Auto forwarded by a Rule
>> >
>> >
>> ----- Original Message -----
>> From: Michael Black <mblack@distcompsols.com>
>> To: <pgsql-questions@postgresql.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
>>
