> -----Original Message-----
> From: Mark Perez [mailto:mperez@whgrp.com]
> Sent: 03 July 2003 20:26
> To: Dave Page; John Bercik; pgadmin support
> Subject: Re: [pgadmin-support] CVS server ?
>
>
> Hello,
>
> I am having a problem when I import and export a table from
> Access 97 after making a change in pgadmin. There are many
> tables in my database that i utilize and I need the interface
> with Access 97.
>
> Is there a reason that Access 97 does not recognize the
> database "after" changes have been made in pgadmin, ie, add a
> column, field, etc.?
>
> If anyone has this answer, or knows someone who does, please
> let me know.
This is a little off topic for this list (pgsql-odbc@postgresql.org is a
better place for Access help), but iirc, Access only examines the table
structure when you initially link it - from that point on it's assumes
to stay the same. Therefore after you change a table you must relink it.
Regards, Dave.