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

Re: @#$%^& Access and PostgreSQL

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: (view raw, whole thread or download thread mbox)
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! 

In response to

pgsql-odbc by date

Next:From: Roderick A. AndersonDate: 2004-06-15 17:31:33
Subject: Re: @#$%^& Access and PostgreSQL
Previous:From: Philippe LangDate: 2004-06-15 14:59:44
Subject: Re: @#$%^& Access and PostgreSQL

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