Advanced Search

Return to Snippet

Revision: 47447
at June 8, 2011 06:46 by wizard04
Initial Code 
set rst = objConn.Execute("SELECT @@IDENTITY")
id = rst(0)
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Get the value of the autonumber field for the last record inserted into an Access database via the current connection.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Get ID of last inserted record in Access

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
database, sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL