As far as I'm aware access doesn't have an last_insert_id() function, so I would agree that it's a MySQL specific thing.
If you use a DAO you can use the following
Private Sub Test192674914368()
Dim lastID As Long
With .CreateQueryDef("", _
"INSERT INTO tblSchoolWorkingDays " & _
"( CALENDAR_DATE ) " & _
"VALUES " & _
"( [prm0] )")
.Parameters(0) = Date
lastID = .OpenRecordset("SELECT @@IDENTITY").Fields(0)
Blatantly stolen from here https://www.access-programmers.co.UK...mp;postcount=8
It's important that you use the same database object to get the ID, in the example posted above it uses CurrentDb.