Re: @#$%^& Access and PostgreSQL - Mailing list pgsql-odbc

From Michael Calabrese
Subject Re: @#$%^& Access and PostgreSQL
Date
Msg-id 40D1D350.1010208@yahoo.com
Whole thread Raw
In response to Re: @#$%^& Access and PostgreSQL  (Joe Conway <mail@joeconway.com>)
Responses Re: @#$%^& Access and PostgreSQL
List pgsql-odbc
Are you getting any error messages.  Are getting the dreaded #DELETED in
the cells after to insert.  You may need to turn row versioning on in
the ODBC settings.
Michael

Joe Conway 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.
>
> HTH,
>
> Joe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly


pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: ado seek ?
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: @#$%^& Access and PostgreSQL