Different BE database uniformity.

I have 1 FE database which can be linked to a number of BE databases. The
BEs are all different Clubs e.g. Sailing Club, Yacht Club, Bridge Club,
Family etc.

Problem is if I change anything in the table structure or relationship of
one of these clubs, I want to make sure I do it with the other clubs as
well.
Has anyone got routine that will check that each BE database has
1) All the tables (even though some will be empty e.g. Bridge club has
nothing to do with boats)
2) The fields are all the same size, default values are the same, Indexes
are the same etc
3) Relationships are identical

I am struggling to do it manually at the moment and I know it is very error
prone

Thanks for any advise

Phil


.

Relevant Pages

  • Re: Merging Data Dynamically
    ... not mind multiple back-ends. ... But if you had told me your Sailing Clubs are all owned by ... then loop through all the tables to detach them from 1 back end database ... sudden addition of Removals5 and create a linked table for it. ...
    (comp.databases.ms-access)
  • Re: Access 2010 SP1 VBA errors
    ... I'm sure my issue of corruption ... Decompile from DOS which works. ... Data\Access\MDB 2010\Decompile Clubs 2012.accdb" /decompile ... This creates a new database "Decompile Clubs 2012.accdb" ...
    (comp.databases.ms-access)
  • Re: copying a backend from within frontend
    ... FE database has a table listing the various clubs and the paths to the BE ... My startupform is unbound, but for some reason the ldb stays alive when it ... recordsets are closed. ...
    (comp.databases.ms-access)
  • Martial Arts Directory - Advertise your club for free
    ... This is a free martial arts directory, with UK and US post code / zip ... codes on the database, which allows users to search for clubs by town, ...
    (rec.martial-arts)
  • Re: Bill Hughes
    ... from Wales, 1 from Northern Ireland, 1 from Isle of Man. ... after about a third of the clubs were in there were no major changes. ... (Leverstock Gn Tues Bridge Club, ... Dermot Canniffe & Joe Canniffe ...
    (rec.games.bridge)