Best methods for selecting, editing data in Access 2000

From: Randall Perry <rgp(at)systame(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Best methods for selecting, editing data in Access 2000
Date: 2001-07-23 01:37:15
Message-ID: B780F6D8.D04C%rgp@systame.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm starting to learn access and would like advice on querying/editing PgSQL
data.

It's my understanding that linked tables bring over a complete table to
Access, then the data is manipulated in Access, so this creates a lot of
network traffic, but is easiest to get running quickly.

I've heard ADO is ok for selects but is problematic for updates. Is this
true?

And could someone tell me the provider settings for a pgsql ADODB.connection
obj? I know a Jet connection is like this

Set conn = New ADODB.Connection
With conn
.Provider = "Microsoft.Jet.OLEDB.4.0"
...
...
...
End With

I have views in my database that are read-only and tables that require
editing. Should I use ADO for the views -- and linked tables or pass-through
queries for tables needing updates?

Any help is appreciated.

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 561.589.6449
mobile email help(at)systame(dot)com

Browse pgsql-odbc by date

  From Date Subject
Next Message Joachim Andree 2001-07-23 07:15:53 No permission to set nextval of sequence
Previous Message Hiroshi Inoue 2001-07-21 16:10:29 RE: ODBC performance with ADO