Re: [GENERAL] PostgreSQL and Access (via ODBC)
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)
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