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


M

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
 
Ad

Advertisements

T

Tony Toews [MVP]

Mark Andrews said:
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/
 
M

Mark Andrews

Thanks, this looks very interesting!

Mark

Tony Toews said:
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/
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top