![]() The problem with that is that I can't create new records with the autonumber. The script works perfectly when I use ServerName, it also works perfectly if I go to the SQL server and change the field to Identity = False. I've looked at many different posts on different websites, but can't figure out how to implement this into my code. When I do this though VB gives the error "Error 3622 - You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column". So to get around this I want to change it from ServerName to record number (ID). The problem is that there can be multiple records with the same server name. Currently I'm using the ServerName field in the multiselect box. I have a form with a multiselect box that I use to update status for several fields for the servers selected. I'm running MS Access 2007, connecting to a MS SQL 2008 R2 server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |