Thread: Had to drop some table columns, managed to annoy MS Access
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
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)
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
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