I am using VS 08(VB) with access 07 to create an application. Throughout the project I have to go back to my database and make changes to the tables. In some occasions when I go to the VS Dataset wizard to refresh and add the changes VS creates a new table instead of adding the changes to the current tables. For examples I have a table called 'products'. I added a new column and when I try to add the changes through VS it creates a new table called 'products1'. Anyone knows of this issue. I try to search for this but it is so specific I cannot get any results. Thanks for the replies guys.
