How to get next available number from MS access

[shahjehan]

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.

[shahjehan]

Thanks,
Let me try it.

[JavaBean]

Quote:

Thanks,
Let me try it.

I dont see any answers

[shahjehan]

i wrote it in mistake. I m new on this forum.