Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FDickschat
Starting Member
1 Post |
 Posted - 2004-08-03 : 10:34:44
|
| Hi Guys,I do have an MS-Access 2000 database (running under Access XP), where all tables are in the backend DB (BE.mdb) and everything else is in the frontend DB (FE.mdb) with linked tables pointing to the backend. The system is live at 1 customer at the moment.During the development I have to modify the backend sometimes with new tables, fields, or indexes.To make the update at the customer easier I would like to create a function which opens the backend of the customer and the development backend, compares all objects inside them and creates an SQL-script in a third DB (update.mdb) which will automatically create all new fields, tables, indexes, properties, etc. (or in the worst case deletes these - I don't know what to do with the data yet, but that is not my question here)The FE.mdb will look for the update.mdb at startup and if it is found will trigger the update function and delete the update.mdb after completion.Does anyone have already done such a thing (in total or in part)? I couldn't find such a thing here in the forum or using Google. I would be very thankful if I had not to build the whole system from scratch.Thanks for your thoughts or any hints where to look else. Any help is appreciated.Frank |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-03 : 19:29:50
|
| I have done some playing around with auto updates in the past, and it's certainly feasible. I had considered creating an "AccessUpdate" add-in, but couldn't find the time to do it properly....Some tips:Use DAO for manipulating tables instead of ADOX. DAO is easier to use and is more reliable for Access manipulation IMHO. You can use the MSysObjects table to great effect when comparing db designs and such. Some of the other MSys tables may also be useful, but I can't think of their names at the momentMake sure you take backups often...Tim |
 |
|
|
|
|
|
|
|
Automatic Update of Backend