Can anyone here give me some advice on methods and strategy for maintaining and upgrading existing Access DBs as my VB6 (not NET) application develops and/or grows?

The story goes like:

MyApp.exe and my MyAccess.MDB are working fine together.

Client asks for modifications that result in adding a Table or Field to the DB or changing the datatype of a field.

I make the necessary changes in my code and my local MDB copy but need to upgrade his current DB to work with the changes.

I'm guessing that I need to write several routines that include:
~Thoroughly detecting the current DB structure to determine the upgrade path.
~Adding necessary Tables.
~Adding necessary Fields to existing Tables and possibly populating certain fields.
~Changing datetypes and reformatting the current data in these fields.

I'm not asking for someone to give me all the code (a couple examples would help), I more interested in the appropriate strategy.

I know this might be a complicated issue but appreciate any & all your wisdom. I'm sure there are others that are approaching this dilemma in their projects.

Thanks in advance,