Update Access DB Schema

[smhcomp]

Hi To All,

I need to create a tool that compares two versions of an Access database and updates the old schema to the new.

I have an Access database that contains the current tables, queries and relationships. I created a form in the mdb and on the OnLoad event, using DAO, it compares the new structure with a separate mdb that contains the old structure. All seems to work fine, but I feel this is creating a maintenance issue. Every time there is a new release, you would need to delete all tables, queries and relationships and create the new structure. There is also the problem that not all users have Access installed on their machine. That would mean that I would have to include the Access runtime files to allow the app to run.

Can this be written in vbscript? Any help to point me in the right direction would be most appreciated.

Thanks,

Sharon

[lotus18]

Every time there is a new release, you would need to delete all tables, queries and relationships and create the new structure.

Why do you need to delete your database?

There is also the problem that not all users have Access installed on their machine. That would mean that I would have to include the Access runtime files to allow the app to run.

I think you don't need to have Access installed on their computer as long as you include all the references (.dll or .ocx). Based on my experience, this was tested and proven. : )

Rey Sean

[smhcomp]

Hi Rey,

Thanks for taking the time to respond.

I would have to delete and or change the database each time the schema changed in order to make sure I have the correct structure of the database.

I was thinking that there may be a more "elegant" way to accomplish this task.

Sharon