Hi,
I have written and distributed my first application using ms acces as
the database and seperately programmed visual basic as the UI.
I need to update the application which required a database change.
What I need to know is how can I re-distribute my application with the
new database schema without over writing the customers existing data.
I need to do this from a distribution disc
Many Thanks
Mark
Giloosh - 23 Jan 2006 00:41 GMT
what kind of change needs to be done with the database?
there are probally a few ways to go about this.
this is the first thing i could think of:
if you are just adding additional tables and fields you can do this
with tabledefs.
looks up createfield tabledef in this news group. you should find alot
of information and examples on it.
write a function in vba that changes the database.
create a new macro that calls that function and than quits ms access.
than you can create a .bat file that calls the macrao:
(ie "c:/programfiles/office/msaccess.exe" "c:/databasefix.mdb" x/
"macro_name")
burn the files to a cd and have the client run the .bat file, and all
of the changes should be made while not touching the current data.
Lyle Fairfield - 23 Jan 2006 00:43 GMT
Probably you need to write code in your VB front end to modify the JET
db. You can test it a million times until you are sure it doesn't mess
with the data. Then you can distribute it. You may need to write code
to check and see if the changes have been made so that they are not
done twice.
marcom61 - 31 Jan 2006 22:29 GMT
> Probably you need to write code in your VB front end to modify the JET
> db. You can test it a million times until you are sure it doesn't mess
> with the data. Then you can distribute it. You may need to write code
> to check and see if the changes have been made so that they are not
> done twice.
>>thankyou for your response. I will try all the suggestions and hopefully it will work
rgds
Mark
mike noel - 23 Jan 2006 06:46 GMT
At the risk of incurring the wrath of the cdma thought police I'll point
you to my free tool (http://home.gci.net/~mike-noel/CompareEM.htm) that
is intended to do exactly what you are asking about.
> Hi,
> I have written and distributed my first application using ms acces as
[quoted text clipped - 8 lines]
> Many Thanks
> Mark