[AccessD] A2003: Calling all Back End Updater Legends

Andy Lacey andy at minstersystems.co.uk
Thu Dec 16 07:19:34 CST 2004


:-)
Lawn bowls? I'm surprised at you. Game for old men isn't it? Or do you play
extreme bowls while bungee jumping? (dons hard hat and heads for shelter)
--
Andy Lacey
http://www.minstersystems.co.uk

PS Sorry about the OT folks. It's the Brit v Aussie competitive thing.



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: RE: [AccessD] A2003: Calling all Back End Updater Legends
Date: 16/12/04 14:07

>
> Hi Andy and Bryan
> Firstly
> Many thanks to all who emailed the VB dll - works well
> (it's a TriGeminal Kaplan and Kreft demo i'm playing with)
>
> WooHoo re the BEU it was the version table
> Changed the number in it to be 1 less than the current mod number an viola
-
> away she goes
>
> Many thanks Bryan and Andy
>
> Hey Andy - See you when you emmigrate - the weather is awesome here as is
> the lifestyle :-))
> Better than PeterBerg (sic) me thinks - The best reds for $8:50 you know
> :-))
> Just got introduced to lawn bowls today - what a hoot - sank a few
sherberts
> afterwards
> got sunburnt as well 100 degree days here - beautiful - plenty of swimming
> ahhhhh
>
> Any northrn hemisphgere bods coming to Sydney soon??
> Feel free to drop me a line
>
> OK enough bragging - back to work (whip cracks above evil face)
>
> Thanks again to all who responded
>
> See y'all
>
> Darren
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
> Sent: Thursday, 16 December 2004 11:32 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] A2003: Calling all Back End Updater Legends
>
>
> Hi Dazzler, how ya doin?
>
> Have you got tblDBAVersion in your BE? If so, open it and see waht version
> it's set to. This needs to be less than the new version you're creating.
If
> not the BEU thinks it is up-to-date. Don't know why it wouldn't be right,
> but have a look.
>
> Another thought. The BEU modules, forms etc need to be in an FE (can be in
> it sown FE like I do, or in with other stuff). The tables it then operates
> on should be in a linked BE. Is that how you have it? The tblDBAVersion
> should have been added to the BE.
>
> Another thing, BEU (at the mo) only works on a single BE MDB. It looks at
> the first linked table and takes its lead from that as to what MDB all of
> your tables are in.
>
> Any of that any use?
>
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
> --------- Original Message --------
> From: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: RE: [AccessD] A2003: Calling all Back End Updater Legends
> Date: 16/12/04 12:09
>
> >
> > Hi Guys
> > OK - I have no problem keeping it on list
> >
> > I imported all the objects from the BEU I downloaded from DBA
> >
> > Cool
> > In the BEU main screen I  started a 'new version'.
> > Just wanted to add a new field called XX to a table called tblTitles
> > Added the stuff to make it a Number field no decimal places etc etc
> > Then clicked on Accept
> > So now I have pending BE Updates - cool
> >
> > I have the RUN CODE =beuDBAIsDBUpToDate() as the first line in the
> > Autoexec Macro
> > Close and reload the dB and I  expected to see the form
frmDBAupgrading
> > flash up and perform the mod
> >
> > So I went to tblTitles - no new field called XX
> > I went to the table tblDBAModifyDatabaseMods there is an entry in
there
> > I went to the table tblDBAModifyDatabase there is an entry in there
too
> >
> > But the mods don't actually take place
> >
> > I had a fellow lister at my place the other day and he was raving how
good
> > the BEU was and
> > showed me how to use it on one of his dB's. No prob it all went well
> >
> > So I imported all the necessary bits and bobs and he couldn't get it
to
> work
> > on
> > my dB. We even imported HIS BEU objects from one of his dB's and we
ran it
> > but
> > still no joy
> >
> > So...
> >
> > Where to from here??
> >
> > many many thanks in advance
> >
> > Darren
> >
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
> > Sent: Thursday, 16 December 2004 6:40 PM
> > To: 'Access Developers discussion and problem solving'
> > Subject: RE: [AccessD] A2003: Calling all Back End Updater Legends
> >
> >
> > On or off-list fire away Darren. Describe where you've got to and
what's
> > happening. And were you a good boy and downloaded the manual and
followed
> > it?
> >
> > -- Andy Lacey
> > http://www.minstersystems.co.uk
> >
> > &gt; -----Original Message-----
> > &gt; From: accessd-bounces at databaseadvisors.com
> > &gt; [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > &gt; William Hindman
> > &gt; Sent: 16 December 2004 02:38
> > &gt; To: Access Developers discussion and problem solving
> > &gt; Subject: Re: [AccessD] A2003: Calling all Back End Updater
Legends
> > &gt;
> > &gt;
> > &gt; ..why not keep it on list ...others (including myself) may
> > &gt; learn something
> > &gt; from your mistakes :)
> > &gt;
> > &gt; William Hindman
> > &gt;
> > &gt;
> > &gt; ----- Original Message -----
> > &gt; From: &quot;Darren DICK&quot;
&lt;d.dick at uws.edu.au&gt;
> > &gt; To: &quot;'Access Developers discussion and problem
solving'&quot;
> > &gt; &lt;accessd at databaseadvisors.com&gt;
> > &gt; Sent: Wednesday, December 15, 2004 6:42 PM
> > &gt; Subject: [AccessD] A2003: Calling all Back End Updater
Legends
> > &gt;
> > &gt;
> > &gt; &gt; Hi Guys
> > &gt; &gt; Can't get the BEU to work
> > &gt; &gt; I even had a very happy user at my place trying to
show me
> > &gt; how to get
> > &gt; &gt; it
> > &gt; &gt; to
> > &gt; &gt; work
> > &gt; &gt; (Hi Deano) - no joy - It works fine on his db's
though
> > &gt; &gt;
> > &gt; &gt; Clearly I have omitted some step or not done
something right
> > &gt; &gt;
> > &gt; &gt; So.can I start a dialogue offlist with a BEU guru
please??
> > &gt; &gt;
> > &gt; &gt; Many thanks
> > &gt; &gt;
> > &gt; &gt; Darren
> > &gt; &gt;
> > &gt; &gt;
> > &gt; &gt; --
> > &gt; &gt; AccessD mailing list
> > &gt; &gt; AccessD at databaseadvisors.com
> > &gt; &gt;
http://databaseadvisors.com/mailman/listinfo/accessd
> > &gt; &gt; Website: http://www.databaseadvisors.com
> > &gt; &gt;
> > &gt; --
> > &gt; AccessD mailing list
> > &gt; AccessD at databaseadvisors.com
> > &gt; http://databaseadvisors.com/mailman/listinfo/accessd
> > &gt; Website: http://www.databaseadvisors.com
> > &gt;
> > &gt;
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> >
> >
> >
>
> ________________________________________________
> Message sent using UebiMiau 2.7.2
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list