Update back-end tables, fields, relationships etc...

[Mark Andrews]

I am looking for some examples of code or links to code examples to update a
back-end database appropriately so it works with the next version of the
front-end. Both dbs are Access2007,

Example: I have a table tblPreference in the back-end that has a
versionNumber field and is set to "1.0". If my latest "2.0" front-end
is opened I want it to detect the OLD version 1.0 back-end and run the code
to update the back-end to "2.0" and then change the version number.

Things I need done include:
- adding fields to existing tables
- deleting fields from existing tables
- changing field types or lengths
- adding new tables
- adding new relationships
- changing data in the tables
- adding links to the new tables in the front-end

Also any tips of how to handle this is multiple users/front-ends are in play
would help.

Thanks in advance,
Mark

 

[Peter Hibbs]

Mark,

The Back End Update Utility code at :-

http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4

does all that.

Peter Hibbs.

 

[Mark Andrews]

Peter,

Thanks that is perfect.

Mark

Mark,

The Back End Update Utility code at :-

http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4

does all that.

Peter Hibbs.

 

[Tony Toews [MVP]]

I am looking for some examples of code or links to code examples to update a
back-end database appropriately so it works with the next version of the
front-end. Both dbs are Access2007,

Compare'Em
http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm
This utility compares the old and new MDB files and creates VBA code
with the differences. Very nice.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Mark Andrews]

Thanks, this looks very interesting!

Mark

Compare'Em
http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm
This utility compares the old and new MDB files and creates VBA code
with the differences. Very nice.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Eighte]

You Love it?

MoneiTakuya.

Thanks, this looks very interesting!

Mark

 

[Mark Andrews]

One of my helpers is going to look at it but first glance it looks good.