Is there an identical comman in Access as SELECT IDENT_CURRENT that I can use? I am trying to execute the following script:
'Get current primary key
sGetID = "SELECT IDENT_CURRENT(Table)"
rs.Open sGetID, conn, 1, 2
session("sGetID") = rs(0)
'End get Primary key
The error is as follows:
Microsoft JET Database Engine error '80040e14'
Undefined function 'IDENT_CURRENT' in expression.