Charlotte Foust
cfoust at infostatsystems.com
Tue Dec 14 13:21:48 CST 2004
MDE files add an additional layer of complications, Lambert. Changing them out does require a recompile of the database that references them. If they're not MDEs, it shouldn't. Charlotte Foust -----Original Message----- From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com] Sent: Tuesday, December 14, 2004 9:13 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Library Database? .mda or .mdb as referenced library-pros or cons? Interesting. I'm going to go off and do some more testing. I thought I'd put this problem to bed years ago as 'just one of those things you have to deal with', but now I'm wondering. I'm talking about plain vanilla code routines stored in an MDE file which is then added as a reference in another application, which in turn is compiled to an MDE file. This is in an Access 97 environment, but I think it also happens with Access 2002 - something else to test. Lambert > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Monday, December 13, 2004 8:32 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Library Database? .mda or .mdb as referenced > library-pros or cons? > > ..not specifically but I do note that when I install updates to 3rd > party > libraries I use, I don't recall ever having to recompile the apps > referencing them. > > William Hindman > > ----- Original Message ----- > From: "Heenan, Lambert" <Lambert.Heenan at aig.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com>; "'John W. Colby'" > <jwcolby at colbyconsulting.com> > Sent: Monday, December 13, 2004 5:06 PM > Subject: RE: [AccessD] Library Database? .mda or .mdb as referenced > library-pros or cons? > > > > Thus far I've not had to create any MDA's, but I see little reason > > to > > think > > that this same problem would not also show up with them. After all it > all > > boils down to the entry point of functions/subs getting changes when > > the library is modified. Why would that not happen with an MDA? > > Have you > done > > an empirical test? > > > > Lambert > > > >> -----Original Message----- > >> From: accessd-bounces at databaseadvisors.com > >> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of John W. > >> Colby > >> Sent: Monday, December 13, 2004 4:07 PM > >> To: 'Access Developers discussion and problem solving' > >> Subject: RE: [AccessD] Library Database? .mda or .mdb as referenced > >> library-pros or cons? > >> > >> That might be true for an MDE but I don't think that is true for an > MDA. > >> > >> John W. Colby > >> www.ColbyConsulting.com > >> > >> Contribute your unused CPU cycles to a good cause: > >> http://folding.stanford.edu/ > >> > >> -----Original Message----- > >> From: accessd-bounces at databaseadvisors.com > >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, > >> Lambert > >> Sent: Monday, December 13, 2004 3:38 PM > >> To: 'Access Developers discussion and problem solving'; 'Dan Waters' > >> Subject: RE: [AccessD] Library Database? .mda or .mdb as referenced > >> library-pros or cons? > >> > >> > >> Just a little heads-up regarding using 'library' files. > >> > >> If you make a change to the library (such as you add a new handy > >> dandy routine to it, or make some alteration to an existing > >> routine) then any and all the applications which are using the > >> library will need to be recompiled. > >> Otherwise you will get a Dr. Watson error when you try to run an > >> application > >> that has a reference to the (now changed) library. > >> > >> Lambert > >> > >> > -----Original Message----- > >> > From: accessd-bounces at databaseadvisors.com > >> > [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Dan > >> > Waters > >> > Sent: Monday, December 13, 2004 11:35 AM > >> > To: 'Access Developers discussion and problem solving' > >> > Subject: RE: [AccessD] Library Database? .mda or .mdb as referenced > >> > library-pros or cons? > >> > > >> > Thanks Charlotte! > >> > > >> > I don't need an add-in, just a library, so I'll just use an mdb > >> > or mde. > >> > > >> > Dan Waters > >> > ProMation Systems > >> > > >> > -----Original Message----- > >> > From: accessd-bounces at databaseadvisors.com > >> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > >> > Charlotte Foust > >> > Sent: Monday, December 13, 2004 10:02 AM > >> > To: Access Developers discussion and problem solving > >> > Subject: RE: [AccessD] Library Database? .mda or .mdb as > >> > referenced library-pros or cons? > >> > > >> > MDA normally designates an add-in library. To function as an > >> > add-in, there is a specific table required. To function as a > >> > library, not. We compile several mdbs into mdes and reference > >> > them as libraries, including the one with all our Redemption code > >> > in it. > >> > > >> > Charlotte Foust > >> > > >> > > >> > -----Original Message----- > >> > From: Dan Waters [mailto:dwaters at usinternet.com] > >> > Sent: Sunday, December 12, 2004 3:03 PM > >> > To: 'Access Developers discussion and problem solving' > >> > Subject: RE: [AccessD] Library Database? .mda or .mdb as > >> > referenced library -pros or cons? > >> > > >> > > >> > Jim, > >> > > >> > After setting a reference to DAO 3.6, and resolving circularity > >> > among function and procedure calls, everything seemed to work > >> > correctly. > >> > > >> > I did set a reference to the Library mda. It appears that doing > >> > this allows the code in the library database to work exactly as > >> > if the > code > >> > existed in the FE mdb. I did not get an initial error the first > >> > time the library code was used. > >> > > >> > I also tried changing the mda to an mdb. Everything still worked > just > >> > as before. So now I'm wondering what the difference is between > >> > an > mda > >> > and an mdb? Any pros/cons to one or the other when using as a > library > >> > database? > >> > > >> > Dan > >> > > >> > -----Original Message----- > >> > From: accessd-bounces at databaseadvisors.com > >> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim > >> > Lawrence > >> > (AccessD) > >> > Sent: Sunday, December 12, 2004 3:56 PM > >> > To: Access Developers discussion and problem solving > >> > Subject: RE: [AccessD] Library Database? > >> > > >> > Hi Dan: > >> > > >> > Not the way you trying to do it. You can create a new MDB/MDE, > >> > with a module and in that module, a group of public variables, > >> > function and subroutines. This will be your library. The MDB/MDE > >> > database will > have > >> > to be attached to your caller/main MDB before the functionality > >> > can > be > >> > accessed. (file/get external data/link...) Just like classes only > >> > public object, in the module can be accessed externally. Note; > >> > that none of the modules objects can be accessed until the module > >> > is formally called > >> > (Example: if your library module is initially called from a Form > >> > open event, you will receive an error but the Form's load event > >> > works > fine.) > >> > and from then on all the functions /subroutines /variables will > >> > be exposed because the whole module is then automatically loaded > >> > into memory. > >> > > >> > HTH > >> > Jim > >> > > >> > -----Original Message----- > >> > From: accessd-bounces at databaseadvisors.com > >> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dan > >> > Waters > >> > Sent: Sunday, December 12, 2004 1:27 PM > >> > To: Database Advisors > >> > Subject: [AccessD] Library Database? > >> > > >> > > >> > I would like to create a separate file (library?) to contain many > >> > procedures and functions which are used by all my customers. > >> > > >> > > >> > > >> > However, most of these either read or write information to the BE > >> > using recordsets. I tried to set up a library database (.mda), > >> > but this errored out when I tried to dim a recordset variable. > >> > The .mda file appears to not recognized the DAO prefix. > >> > > >> > > >> > > >> > dim rst as DAO.Recordset > >> > > >> > > >> > > >> > Is there a way to create a database file to contain procedures > >> > and functions, called from the FE mdb, that can be used > >> > read/write to tables in the BE mdb? > >> > > >> > > >> > > >> > Thanks! > >> > > >> > Dan Waters > >> > > >> > -- > >> > 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 > >> > > >> > -- > >> > 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 > > > -- > 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