Re: [GENERAL] PostgreSQL and Access (via ODBC)

[Froilan Mendoza]

On Wed, 12 Jul 2000, Sean Weissensee wrote:

> When importing in Access, it would have prompted you to select a unique
> ID for each table, did you assign this ?

Im pretty new to this, so please bear with me :)

if unique id ~= create unique index myindex on table (field)

then yes ...

if not, how do you assign a unique id?

TIA again.

---
Froilan C. Mendoza  
Tridel Technologies, Inc.
http://www.tridel.net

Re: [GENERAL] PostgreSQL and Access (via ODBC)

[Sean Weissensee]

Within Access, click file, get external data, link tables,

choose ODBC, select the postres driver,

select the DSN,

this will bring up a window to select tables from the db,

highlight the tables, click ok,

at this stage if a unique ID was not set in the postgre table a window will
appear to choose a unique id,
if Access does not get this you will not be able to add or update any
records.

Hope this helps,

Sean