Skip site navigation (1) Skip section navigation (2)

Re: Views and Access 2000

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Nick Haw' <nick(dot)haw(at)operagrp(dot)com>,"'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Views and Access 2000
Date: 2002-06-18 11:30:49
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748F6@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello,
	If you create a table with suitable fields, including a primary key
and then use a select rule this will do it.
hth,
- Stuart

-----Original Message-----
From: Nick Haw [mailto:nick(dot)haw(at)operagrp(dot)com]
Sent: 12 June 2002 16:46
To: 'pgsql-interfaces(at)postgresql(dot)org'
Subject: Views and Access 2000


OK, i have some views that I need people to be able to use in Access 2000.
When I try an link them using my ODBC data source I always get a dialogue
box which says "select unique record identifier" even though the table the
view is using has got a primary key. I don't want this box to appear, is
there anyway I can stop it?

pgsql-interfaces by date

Next:From: Nookala Satish KumarDate: 2002-06-18 12:11:13
Subject: Re: [JDBC] JDBC problem
Previous:From: Lee KindnessDate: 2002-06-18 11:02:30
Subject: ECPG: CREATE TABLE ... FOREIGN KEY(col) REFERENCES table(col)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group