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

Re: @#$%^& Access and PostgreSQL

From: Joe Conway <mail(at)joeconway(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 01:23:47
Message-ID: 40CE4FA3.2020100@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

HTH,

Joe

In response to

Responses

pgsql-odbc by date

Next:From: Greg CampbellDate: 2004-06-15 13:30:49
Subject: Re: [Maybe Spam] @#$%^& Access and PostgreSQL
Previous:From: Roderick A. AndersonDate: 2004-06-14 23:50:19
Subject: @#$%^& Access and PostgreSQL

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