Results 1 to 5 of 5
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    Why inserting new record is not working?

    Hi Guys,

    i have query relationships in Access like here:

    Click image for larger version. 

Name:	Screenshot_3.png 
Views:	23 
Size:	47.5 KB 
ID:	33635

    but when i have FE in Access and BE in PostgreSQL (link tables) i can not add new records,
    the same relationships here:

    Click image for larger version. 

Name:	Screenshot_4.png 
Views:	23 
Size:	86.0 KB 
ID:	33636

    why is that?

    Best,


    Jacek

  2. #2
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    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 ↓↓

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    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

  4. #4
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    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 ↓↓

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    aaa nice Minty thank you !

    Best,
    JAcek

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 02-28-2018, 01:02 PM
  2. Replies: 4
    Last Post: 07-21-2015, 02:50 PM
  3. Syntax error when inserting new record
    By The in forum Queries
    Replies: 10
    Last Post: 11-20-2014, 07:53 PM
  4. Replies: 14
    Last Post: 03-19-2013, 12:16 AM
  5. Replies: 2
    Last Post: 10-10-2012, 07:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums