BE Schema changes

[Clif McIrvin]

(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.

 

[Tony Toews]

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.

Compare'Em
http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-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/

 

[Jens Schilling]

Hi, Clif

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

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

 

[Lutz Uhlmann]

You can try

Total Access Detective
(http://www.fmsinc.com/MicrosoftAccess/DatabaseCompare.html)

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

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

Lutz

 

[a a r o n . k e m p f]

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

 

[a a r o n . k e m p f]

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

 

[Tony Toews]

or DDL queries to change tables / columns, etc

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/

 

[Access Developer]

"Tony Toews" <[email protected]> replied to "(e-mail address removed)"

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

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

 

[David-W-Fenton]

"Tony Toews" <[email protected]> replied to
"(e-mail address removed)"


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).

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.

 

[a a r o n . k e m p f]

Tony;

you're wrong.. anything is possible is DDL.

SQL Server writes a LOT of DDL for you automatically.. that's why you
don't know anything about it.. because you're a JET CRYBABY PUSSY.

-Aaron

 

[Stuart McCall]

message

Tony;

you're wrong.. anything is possible is DDL.

SQL Server writes a LOT of DDL for you automatically.. that's why you
don't know anything about it.. because you're a JET CRYBABY PUSSY.

Whereas you're just an amusing distraction.

 

[Jim Devenish]

Tony;

you're wrong.. anything is possible is DDL.

SQL Server writes a LOT of DDL for you automatically.. that's why you
don't know anything about it.. because you're a JET CRYBABY PUSSY.

-Aaron

I do not understand why you can't make your contribution without being
offensive. It is not at all helpful.

 

[David-W-Fenton]

m:

I do not understand why you can't make your contribution without
being offensive. It is not at all helpful.

Take out the offense, and he still hasn't made a contribution.

Everything Aaron posts is WRONG, even "and" and "the".

 

[a a r o n . k e m p f]

Jim;

Eat shit and lose the training wheels.

Jet is for mental midgets.
SQL Server kicks ass.

Jet corrupts data.

MVPs are a bunch of pussies.

-Aaron

 

[Access Developer]

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

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