depending on what version of access you are using, in access 2000 and later, you can doINSERT INTO GuestBook ([Name]) VALUES(?)thenSelect @@IDENTITYsee http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconRetrievingIdentityOrAutonumberValues.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconRetrievingIdentityOrAutonumberValues.asp