i have a mock site im working on in asp.net/vb.net using an access database. after employees log in they can update there employee profile by filling out a form. i need to know the code for updating an access DB with vb.net from the form fields. im lookin for the syntax on the SQL string and the execute commands afterwards. could someone help me with this or perhaps show me your code for some ideas to point me in the right direction?
also, what would be a good DB to use online? i know access well but i've heard that it doesnt work well online because only one person can access the DB at a time. any free DB's out there that i can scoop?