Thread: Had to drop some table columns, managed to annoy MS Access

Had to drop some table columns, managed to annoy MS Access

From
Cheryl Thompson
Date:
Ok,
I designed a simple DB (5 tables) using psql through cygwin (running ipc, too) on Windows 2000.
My users will be (most likely) using Access as a front end. As I actually know my way around Access, I was using it for data entry.
 
However,
I discovered some of my fields were not large enough, etc. when entering test data (which is why you use test data to test :D).
 
I used psql alter commands to drop columns and add new ones (no data to loose), and then went in and deleted all my linked tables in Access and tried to relink.
 
I'm getting the following:
'..............pg.dropped.8........................' is not a valid name. Make sure that it does not contain invalid characters or punctuation and that it is not too long.
 
This is the psql \d information for the table in question:
                                     Table "public.event"
    Column    |      Type       |                          Modifiers
--------------+-----------------+-------------------------------------------------------------
 aeventid     | integer         | not null default nextval('public.event_aeventid_seq'::text)
 title        | character(500)  | not null
 alocationid  | smallint        | not null
 asponsorid   | smallint        | not null
 notes        | character(1000) |
 description  | character(3000) | not null
 contactphone | character(20)   |
 adateid      | smallint        | not null
 pricehigh    | numeric(9,2)    |
 pricelow     | numeric(9,2)    | not null
 category     | character(20)   | not null
 contactname  | character(150)  |
 contactemail | character(200)  |
Indexes: event_pkey primary key btree (aeventid)
 
Can someone explain what's going on, and more importantly, what I can do about it?
 
I didn't create this DB through a script.. I would prefer not to have to recreate it again. Ugh.
 
Thanks,
Cheryl in Irving

Re: Had to drop some table columns, managed to annoy MS Access

From
Tom Lane
Date:
Cheryl Thompson <cthompso@ci.irving.tx.us> writes:
> I'm getting the following:
> '..............pg.dropped.8........................' is not a valid name.

Are you using an up-to-date ODBC driver?  It looks like the one you have
is not aware of the attisdropped column in pg_attribute ...

            regards, tom lane