From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
---|---|
To: | "Roderick A(dot) Anderson" <raanders(at)acm(dot)org> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: @#$%^& Access and PostgreSQL |
Date: | 2004-06-15 15:16:59 |
Message-ID: | 20040615151659.36113.qmail@web20804.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
--- Joe Conway <mail(at)joeconway(dot)com> wrote:
> Roderick A. Anderson wrote:
> > Short story. Pg 7.2 running on a Linux box. MS
> Access 2000 on WinXP Pro.
> > I can query and fiddle with the data in Access but
> I haven't figured out
> > how to get the changes back into Pg.
>
> >
> > Quick; please someone hit me with a cluestick! Or
> if it's too far to
> > reach is there a tutorial on using MS Access and
> Pg together?
>
> It's been a long time since I've messed with
> MSAccess/pgsql, but IIRC,
> you need to be sure your table has a primary key
> defined to get a
> writeable recordset. Also, make sure the linked
> table on the Access side
> reflects that.
Good points: always refresh (or relink) your linked
tables after making changes to tables on the server
side; also, I find life becomes much easier with
Access when I use a serial primary key on every table
as a matter of course.
Have you created your tables without oid's? I believe
that could cause you a problem, because the ODBC
driver expects oid's in some circumstances. In any
case, I suggest you set the "row versioning" driver
setting to true.
The suggestion elsewhere to turn on logging, on both
client and server sides, is a good one.
>
> HTH,
>
> Joe
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list
> cleanly
>
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Roderick A. Anderson | 2004-06-15 17:31:33 | Re: @#$%^& Access and PostgreSQL |
Previous Message | Philippe Lang | 2004-06-15 14:59:44 | Re: @#$%^& Access and PostgreSQL |