Have you set any constraints on the tables in PostgreSQL?
Can you open the tables directly and manually insert a record ?
If not have you connected with the correct permissions to allow records to be added.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Hello Minty,
thank you.
YEs i have constraints in postgresql, primary and foreign keys.
Yes i can add values directly within tables.
Permissions are set up to Admin.
Hmm when i added Primary keys from tables the possibility to add new records is displayed now.
Why this is happening?
Best,
jacek
ODBC drivers require a primary key to keep track of which record they are dealing with.
without those - no updates as you discovered!
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
aaa nice Minty thank you !
Best,
JAcek