Hi Zlatko,
You mentioned: "Use serial or serial4 to create auto-values. Don't
use any bigint-types like bigserial. Access doesn't like 8-byte-ints.".
Could you please explain why you don't recommend bigserial for primary
key ?
I use bigserial primary keys in Postgres tables, and din't rea
s in Postgres tables, and din't realise problems
with MS Access front-end. What problems could I expect ?
Thanks,
Zlatko
- Original Message -
From: "Andreas" <[EMAIL PROTECTED]>
To: "Ets ROLLAND" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, July 24, 2
Ets ROLLAND schrieb:
For all the data created BEFORE the transfert to PostgreSQL, all works
fine.
For the records created SINCE this transfert, it is impossible to
modify or delete these records !?
MS-Access say that "The record is acceded by an other user", even I am
the only user.
As Rich
Ets ROLLAND wrote:
Hello !
I made the port of an Access 2002 Database to PostgreSQL 8, it seems to work.
I still use MS-Access 2002 for the application, using ODBC with linked tables.
For all the data created BEFORE the transfert to PostgreSQL, all works fine.
For the records created SINCE this
Hello !
I made the port of an Access 2002 Database to
PostgreSQL 8, it seems to work.
I still use MS-Access 2002 for the application,
using ODBC with linked tables.
For all the data created BEFORE the transfert to
PostgreSQL, all works fine.
For the records created SINCE this transfert, i