Updating an access database
Corwin earned the title of "Effective Communicator" from the International Training in Communication organization.
She holds a Bachelor of Science in psychology from The Ohio State University.
if you have the lastname in the where clause, there are still chances of updating multiple records if you have many customers with the same last name.
"; I have Customer ID but it is auto increment in Access Do I need to change something down in the code.
The best way to handle this type of event, the updating of many records in a database table, is to use an Update Query to make the changes to data in one operation.Now consider the following scenario example, that will illustrate the use of a Microsoft Access Update query: One of your product suppliers has decided to increase the price of their products by 3 percent (%) across the board.You have decided that you will use an Update Query to change all of the relevant records in your Products table. Thank you so much, that was where my problem was, it was the date. Besides this is just an internal project, not a public release. " cmd = New Ole Db Command(str, my Connection) cmd. Add With Value("@jounal Title", My Journal Title ) cmd. Add With Value("@journal Text", My Journal Text) cmd. I just used Hansup's method for a quick fix, however i will look into parametrized queries for future use.