[AccessD] A2003: Calling all Back End Updater Legends

Reuben Cummings reuben at gfconsultants.com
Thu Dec 16 08:07:02 CST 2004


And did you make the necessary code additions to your relinking code?

Can't remember the process, but this would also cause a problem.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bryan
Carbonnell
Sent: Thursday, December 16, 2004 8:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003: Calling all Back End Updater Legends


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!"
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list