>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.

You will have to have a copy of Access (correct version) to accomplish this. VB will not work. The query is stored within the mdb file along with everything else.

Tom