Results 1 to 4 of 4
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Fumbling through Nulls Issue

    As I said, I am just Fumbling through this with almost no understanding of what I am doing.

    recently uploaded my back end tables to a server via SQL Server (not me, I had to have someone else do it) now I am just trying to go through and get everything working like it did when it was a single access db

    anyway, I was trying to enter a new record in a subform


    i can enter the information into the new record line but cant move forward from there (which makes sense because of the error is saying i have a null somewhere)

    the error is


    [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert the value NULL into column 'DuesTrackID',table'db789011d180ae44c8acc5ad100006 8.dbo.tbl_ChapterDuesTrack'; column does not allow nulls. INSERT fails(#515)[Microsoft....... The statement has been terminated(#3621)

    I understand this is saying I cant insert a NULL into the column 'DuesTrackID'

    I don't understand why it is trying to insert a NULL into that column (maybe a stupid question but shouldn't it be auto entering the next ID# if it is the PK Field)

    Thanks for the help,

    Click image for larger version. 

Name:	Capture.jpg 
Views:	17 
Size:	122.0 KB 
ID:	45570
    Click image for larger version. 

Name:	Capture2.PNG 
Views:	17 
Size:	102.2 KB 
ID:	45571

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    I have never played with SQL Server and Access, but shouldn't the Identity Increment be at least 1?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168
    Yeah, I was just realizing that this is related to (or the exact same) problem I had a few months ago,
    the solution as I understand it is I have to delete and re-create the entire table because the properties of that field can not be edited.
    well, maybe this time I will learn it well enough to remember it

    Click image for larger version. 

Name:	Capture.PNG 
Views:	17 
Size:	60.2 KB 
ID:	45572

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    As you probably now realize,
    In SQL Server, the Identity property is the equivalent of Access Primary Key Autonumber.

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

Similar Threads

  1. Summing Nulls
    By mindbender in forum Queries
    Replies: 13
    Last Post: 11-28-2017, 01:38 PM
  2. How to join on fields containing nulls
    By Atoga in forum SQL Server
    Replies: 3
    Last Post: 11-27-2015, 08:55 AM
  3. Nulls problem, hmm
    By redbull in forum Programming
    Replies: 6
    Last Post: 06-29-2012, 12:16 PM
  4. SUM in regards to nulls
    By detlion1643 in forum Access
    Replies: 5
    Last Post: 02-03-2010, 08:50 AM
  5. GetRows - Invalid Use of Nulls
    By Wannabe_Pro in forum Programming
    Replies: 3
    Last Post: 07-22-2009, 07:07 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