By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Update Access DB Schema

P: 2
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
Nov 26 '07 #1
Share this Question
Share on Google+
2 Replies


lotus18
100+
P: 866
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
Nov 27 '07 #2

P: 2
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
Nov 27 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.