Bryan Carbonnell
carbonnb at gmail.com
Thu Dec 16 07:33:51 CST 2004
On Thu, 16 Dec 2004 23:05:05 +1100, Darren DICK <d.dick at uws.edu.au> wrote: > 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?? I just tried this using A2K and it worked here, so here are a couple of things to look at/that spring to mind: 1) Does the autoexec macro actually fire? 2) Do you have a reference set to the DAU libraries? The BEU uses DAO. 3) Does the BEU fire with you manually run beudbaisdbuptodate from the VBEs immediate window? 4) In A2K the function name parameter for RunCode is beuDBAIsDBUpToDate () which is missing the = that you have. I've never used A2K3 and I don't have access to it, so I can't do any actual testing :( -- Bryan Carbonnell - carbonnb at gmail.com Life's journey is not to arrive at the grave safely in a well preserved body, but rather to skid in sideways, totally worn out, shouting "What a great ride!"