Re: @#$%^& Access and PostgreSQL

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