I'm tossing this around in my head, but I thought I might make use of your input.
We one of our VB applications uses an Access backend (I KNOW). I need a way to modify the table design in the customers database without losing any of their data. All we need to do is add two fields.
My thought processes so far. Piggyback a database with the new table design with a VB update exe. We know where the customer database is saved. Somehow we need to import our new design into the customer database and then....
well, this is where my ears started smoking. I don't think I can use an append query because the the table structures are different. Can I use TableDefs to do this?
We one of our VB applications uses an Access backend (I KNOW). I need a way to modify the table design in the customers database without losing any of their data. All we need to do is add two fields.
My thought processes so far. Piggyback a database with the new table design with a VB update exe. We know where the customer database is saved. Somehow we need to import our new design into the customer database and then....
well, this is where my ears started smoking. I don't think I can use an append query because the the table structures are different. Can I use TableDefs to do this?
