(Crossposted to cdma / mpa)

Does anyone have VBA code for modifying JET/ACE backend schema they
would be willing to share?

My company has a "work in progress" (that is, the app itself is a work
in progress) database app in use in two different cities, and I'm
looking for a mechanism to keep the structure of the two dbs consistent.
As each office uses the database for their own data it seems that
emailing a copy of the modified backend to the other location is a
non-starter.

Any and all suggestions welcomed.


--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

On Sat, 6 Nov 2010 10:36:35 -0500, "Clif McIrvin"
<clare.nomail (AT) gmail (DOT) com> wrote:

Compare'Em
http://home.gci.net/~mike-noel/Compa...reEM-About.htm

I have a backend version number in a table. My startup code takes a
look at that number and then decides what update subroutines to run.

Of course in the code produced by the above utility you can run action
queries to clean up data and so forth.

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/

Hi, Clif

Clif McIrvin wrote:
I've found the "Upgrade2K.ZIP" in my collection:

http://www.weascend.com/Downloads/DownloadPage.htm

Maybe it's worth to take a look at it.

Regards
Jens

You can try

Total Access Detective
(http://www.fmsinc.com/MicrosoftAcces...seCompare.html)

or the older but free MDBDiff
(http://www.wintestgear.com/products/...d/MDBDiff.html)

I use this tools to compare my databases and then i create
update-scripts to deploy the changes.

Lutz

you should be using SQL Server.. there are plenty of tools for that in
SQL Server land



On Nov 6, 7:36*am, "Clif McIrvin" <clare.nom... (AT) gmail (DOT) com> wrote:

or DDL queries to change tables / columns, etc

of course, since you have to actually write SQL- I'm sure this
precludes the MVPs from using it





On Nov 6, 10:38*am, Tony Toews <tto... (AT) telusplanet (DOT) net> wrote:

On Tue, 9 Nov 2010 07:00:41 -0800 (PST), "a a r o n . k e m p f @ g m
a i l . c o m" <aaron.kempf (AT) gmail (DOT) com> wrote:

Using DAO to update an Access database schema gives you a lot more
functionality.

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/

"Tony Toews" <ttoews (AT) telusplanet (DOT) net> replied to "aaron.kempf (AT) gmail (DOT) com"
<aaron.kempf (AT) gmail (DOT) com>:

Tony, Mr. Kempf knows even less about Access than he knows about SQL Server
(which means his Access knowlege is somewher between "none" and "next to
none", because when he tries to impress people by being specific about SQL
Server, he comes off looking stupid almost every time).

Larry

"Access Developer" <accdevel (AT) gmail (DOT) com> wrote in
news:8k0hk1F3ahU1 (AT) mid (DOT) individual.net:

If he knows less about Access than he knows about SQL Server, he's
clearly in negative territory.

Indeed, this can be scientifically demonstrated by examining his
posts in the Access newsgroups, which clearly decrease the amount of
truth posted there.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf (AT) gmail (DOT) com> wrote

Mr. Kempf, if your answers indicated any real knowledge of either Access or
SQL Server, your comments would have had more impact. They obviously have
none.

Vague claims such as "plenty of tools", without reference to even a single
one, means you have made no contribution to the discussion.

Larry Linson