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
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 |