[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