Rolling out Access DB structure changes...

[JohnW]

Hi,
I have a number of installations that have a current version of an
Access DB, however the latest version of my software required a change
to the DB structure. Is there any way I can include a 'script' to
easily apply all the DB changes without having to apply them manually?

Thanks in advance,
John

 

[Nikos Yannacopoulos]

John,

Check out the auto FE updater at Tony Toews's site:

http://www.granite.ab.ca/access/autofe.htm

It's probably what you need, not just for now, but for ever!

HTH,
Nikos

 

[Tim Ferguson]

(e-mail address removed) (JohnW) wrote in

Is there any way I can include a 'script' to
easily apply all the DB changes without having to apply them manually?

Yes: just create a Database object or a Connection object to the back end
database and stick the DDL strings into the db.Execute method.

The think to get right is versioning, and working out which changes are
needed on which databases. I tend to use the
db.Containers("Databases").Documents("UserDefined") properties, because you
can set them from the Database Properties dialog if they get screwed up by
the code...

Hope that helps


Tim F

 

[JohnW]

Thanks Guys, sounds quite straight-forward.

John