Thanks for the reply though..sorry for the confusion.var microsoft = microsoft
Access update query not updating
To maintain data integrity, the fields in an Access database are set to accept a specific type of data, such as text or numbers.
If you don't enter the correct data type, Access displays an error message.
You can navigate between records by using the navigation buttons.
Arrow buttons Click to conveniently navigate to the first, previous, next, or last record. Current Record Type a record number and then press ENTER to navigate to that record.
The following code does not update my SQL Server table.