Thread: How to get next available number from MS access
View Single Post
  #1 (permalink)  
Old 11-18-2007, 09:03 PM
shahjehan shahjehan is offline
Member
  
Join Date: Nov 2007
Posts: 3
shahjehan is on a distinguished road
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
Sponsored Links