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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly