Results 1 to 4 of 4
  1. 11-18-2007, 07:03 PM #1
    shahjehan
    shahjehan is offline Member
    Join Date
    Nov 2007
    Posts
    3
    Rep Power
    0

    Smile How to get next available number from MS access

    Dear alll,

    How I can get next available number (Primary Key) from MS access. There is a function of MS access Nz(DMax("+"Acc_id"+","+"Accessories"+"))+1. but it is not working in java. is there any funtion.


    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 11-18-2007, 07:05 PM #2
    shahjehan
    shahjehan is offline Member
    Join Date
    Nov 2007
    Posts
    3
    Rep Power
    0

    Default

    Thanks,
    Let me try it.
    Reply With Quote Reply With Quote
  3. 11-18-2007, 07:37 PM #3
    JavaBean's Avatar
    JavaBean
    JavaBean is offline Moderator
    Join Date
    May 2007
    Posts
    1,270
    Rep Power
    10

    Default

    Thanks,
    Let me try it.
    I dont see any answers :)
    Reply With Quote Reply With Quote
  4. 11-18-2007, 07:41 PM #4
    shahjehan
    shahjehan is offline Member
    Join Date
    Nov 2007
    Posts
    3
    Rep Power
    0

    Default

    i wrote it in mistake. I m new on this forum.
    Reply With Quote Reply With Quote
« Jdbc | reset query »

Similar Threads

  1. how to use Scanner with a number
    By cew27 in forum New To Java
    Replies: 10
    Last Post: 04-03-2009, 06:23 PM
  2. Help with access a database using Microsoft Access
    By cachi in forum JDBC
    Replies: 1
    Last Post: 08-07-2007, 07:51 AM
  3. how to know the number of bytes
    By gabriel in forum New To Java
    Replies: 2
    Last Post: 08-06-2007, 05:13 PM
  4. how to know the number of the line
    By simon in forum New To Java
    Replies: 3
    Last Post: 08-01-2007, 04:59 PM
  5. Help with setting number as even or odd
    By fegiflu in forum New To Java
    Replies: 8
    Last Post: 07-24-2007, 06:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules