Darren DICK
d.dick at uws.edu.au
Thu Dec 16 08:04:31 CST 2004
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 > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > > William Hindman > > Sent: 16 December 2004 02:38 > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] A2003: Calling all Back End Updater Legends > > > > > > ..why not keep it on list ...others (including myself) may > > learn something > > from your mistakes :) > > > > William Hindman > > > > > > ----- Original Message ----- > > From: "Darren DICK" <d.dick at uws.edu.au> > > To: "'Access Developers discussion and problem solving'" > > <accessd at databaseadvisors.com> > > Sent: Wednesday, December 15, 2004 6:42 PM > > Subject: [AccessD] A2003: Calling all Back End Updater Legends > > > > > > > Hi Guys > > > Can't get the BEU to work > > > I even had a very happy user at my place trying to show me > > how to get > > > it > > > to > > > work > > > (Hi Deano) - no joy - It works fine on his db's though > > > > > > Clearly I have omitted some step or not done something right > > > > > > So.can I start a dialogue offlist with a BEU guru please?? > > > > > > Many thanks > > > > > > Darren > > > > > > > > > -- > > > 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 > > > > > > -- > 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