My database is still in flucts... It's still changing as we're still designing the entire process/product. I'm restricted to using MS Access.
THE PROBLEM:
Whenever I change the underlying database structure, say add a field, or change it's properties(from a string to a date/time)... Then I try to activate that change in my dataset-designer window... It doesn't work.

I changed three tables in Access: two, I selected a 'primary-key', a third one I changed field properties. Then I open VS8, removed the tables from the designer window and tried to drag/drop them back from the server-explorer.

It gives me an error code of -1 and nothing else... nada... no more info.

When I tried to view one of my forms, it had an error, since I hada a datagrid tied to one of the tables I changed. The only way I could view it was to comment to form-designer code to eliminate the datagrid. Now I have to re-do two hours of work because the datagrid isn't there anymore... because I deleted the table and "can't" copy in a version....

I desperately need some help! I don't want to have to 'rebuild' a form/and-of-the-underliying-code everytime I need to make a change to my database description. The 'refresh' button... doesn't do anything. I have to 'modify' the connection and then 'drag/drop' a table onto the designer window... then it does something, but then I have an extra table definition, as well as broken links between forms and database....

This keeps happening whenever I have to change the underlying database....

There's has got to be a better way... or at least some kind of definite 'process'... some series of steps to follow to do this and not have it break it's links....


Very Frustrated!(rcloud)