I am using an Access database to store my VB data. It has, of course, several tables and queries. It is on a pc that does not have Access, so I cant go in and modify a table or query using Access. I have to use VB to accomplish this. My questions are.......

1) To change the design on a query, cant I just change the query on MY pc, upload it to the user pc, and use VB to delete the old query, and add the new one?

2) If I need to change a tables design, that has thousands of records, is it best to build a new DB, import the data from the old DB, then delete the original and rename the new to the old?

And all of this must be done using VB6.

Any examples would be greatly appreciated.