pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Dobie <simon@auditbureau.org.au>
To: pgsql-interfaces@postgresql.org
Subject: Problems when using MS Access to display Postgres Data
Date: Mon, 03 May 2004 09:56:26 +1000
Message-ID: <40958AAA.30707@auditbureau.org.au> (raw)

Hi,

Im not sure if this is the right mail list, apologies if it is not, and 
could someone let me know where i could post this question if its not 
the right place.

Basically, i have a small pg database with about 628 records in it. I 
have these tables linked into an access database so that i can use 
access forms and reports for people to easily get around in the 
database. However, i just imported 20 records or so, and when i open up 
the linked table to check, it seems like the first record was imported 
20 times. however, when i open PGAdminIII up and view the data, its fine.

I can Run the linked table manager and update linked tables, and i get 
the right data, but then my table becomes un editable and none of my 
forms work.

Does anyone have any clues for how to fix this?! its driving me insane!!

%simon



Message-ID: <40958AAA.30707@auditbureau.org.au>
Permalink:  ../40958AAA.30707@auditbureau.org.au/
Also on:    postgresql.org/message-id/40958AAA.30707@auditbureau.org.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: simon@auditbureau.org.au
  Subject: Re: Problems when using MS Access to display Postgres Data
  In-Reply-To: <40958AAA.30707@auditbureau.org.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox