Josh,
> My guess is that the table definition has changed since you
> attached it from access. I'd suggest dropping the linked table
> and re-linking it.
I assure you that isn't the case for two reasons:
1) I'd be the one changing the table definition, and I haven't been
2) I've been linking & unlinking so much it's HIGHLY unlikely.
> For further help, I suggest joining the pgsql-odbc mailing
> list and/or the pgodbc project's mailing list.
Good suggestion, thanks!
--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: Thursday, April 24, 2003 4:29 PM
> To: David Olbersen; pgsql-novice@postgresql.org
> Cc: pgsql-general@postgresql.org
> Subject: Re: [NOVICE] ODBC & Access [Try 2]
>
>
> David,
>
> > 7 of them work just fine and I can see all the data in them.
> > The last one though, only displays '#DELETED' for each column
> > of each row. I checked the permissions on all the tables and
> > they're the same -- I have read access (all I need for now, right?)
> >
> > Any idea what's going on? This is PostgreSQL 7.3.2 on
> FreeBSD with the
> PostgreSQL ODBC driver version 7.02.00.05 on Win XP.
>
> My guess is that the table definition has changed since you
> attached it from
> access. I'd suggest dropping the linked table and re-linking it.
>
> For further help, I suggest joining the pgsql-odbc mailing
> list and/or the
> pgodbc project's mailing list.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
>