Please remove spaces from the column name.
Ben Trewern wrote:
>
> There are two separate problems I am having -
>
> 1. You can connect any table in Access 97 and use it in that session but if
> you close the database (mdb file) and open it again you get a GPF on opening
> the table.
>
> It seems to happen with which ever table I open. I think it must be a
> problem with the ODBC 3 driver because I didn't have this problem before
> upgrading.
>
> 2. This problem is more interesting:
>
> I have a table similar to :
>
> CREATE TABLE public.subs (
> subcontractorid varchar(10),
> "payment number blue" int2,
> description text
> );
>
> I link it into Access 97 and open the table. It opens correctly, but after
> approx 8 seconds all the data turns to #Name? . I've looked at the
> mylog_xxx.log file and have found the following:
>
> [3704]send_query(): conn=42153888, query='SELECT "subcontractorid","payment
> '#S_C_H#' blue","description1","xmin" FROM "public"."subs2" WHERE
> "subcontractorid" = 'ARB' OR "subcontractorid" = 'ARCMOR' OR
> "subcontractorid" = 'ARROW' OR "subcontractorid" = 'ASBESTEC' OR
> "subcontractorid" = 'ASH' OR "subcontractorid" = 'ashbrook' OR
> "subcontractorid" = 'ASHCROFT' OR "subcontractorid" = 'ASPHALTIC' OR
> "subcontractorid" = 'ASSOCIATED' OR "subcontractorid" = 'ATLAS''
>
> as you can see "payment number blue" has been replaced by "payment '#S_C_H#'
> blue" I assumed from this that the word 'number' was the problem so renamed
> the field "pay no blue" but I still get the problem.
>
> Any Ideas?
>
> BTW I am using Postgres 7.3.2 on Mandrake linux 8.1, Windows XP sp1, Access
> 97 sr2
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/