BE Schema changes

  • Thread starter Thread starter Clif McIrvin
  • Start date Start date
C

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.
 
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.
Click to expand...

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/
 
you should be using SQL Server.. there are plenty of tools for that in
SQL Server land
 
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" <[email protected]> replied to "(e-mail address removed)"
Using DAO to update an Access database
schema gives you a lot more functionality.
Click to expand...

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
 
"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).
Click to expand...

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.
 
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
 
Back
Top