[AccessD] Library Database? .mda or .mdb as referenced library-pros or cons?

John W. Colby jwcolby at colbyconsulting.com
Mon Dec 13 15:06:40 CST 2004


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






More information about the AccessD mailing list