From: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> |
---|---|
To: | "Andreas" <maps(dot)on(at)gmx(dot)net>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ? |
Date: | 2009-08-13 11:36:54 |
Message-ID: | E6A0649F1FBFA3408A37F505400E7AC21F8625@email.attiksystem.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
pgsql-odbc-owner(at)postgresql(dot)org wrote:
> Hi,
>
> I've got an Access-App using PG 8.4 in a LAN.
> The systems dude said he updated to odbc 8.400 on all clients.
> Though the same issue appeared with PG 8.3.7 and odbc 8.2.5 before.
>
> Among others, there are 2 tables sitting in a schema.
> Their primary keys are sequences.
> I link those tables into access and the keys are shown as autovalue
> as expected.
>
> When Access tries to add a record, it complains that the relation
> "versandinfos_versandinfo_id_seq" wouldn't exist and throws an error
> #7.
Hi,
Have you checked if your ODBC user has enough rights on your sequence
"versandinfos_versandinfo_id_seq"? You can use pgAdmin to check that.
Regards,
-----------------------------------------------------------------------
Philippe Lang Web : www.attiksystem.ch
Attik System Email : philippe(dot)lang(at)attiksystem(dot)ch
rte de la Fonderie 2 Phone : +41 26 422 13 75
1700 Fribourg Mobile : +41 79 351 49 94
Switzerland Fax : +41 26 422 13 76
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2009-08-13 15:54:51 | Re: Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ? |
Previous Message | Andreas | 2009-08-13 09:34:28 | Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ? |