[AccessD] Library Database? - Never Mind

It might help to set a reference to DAO 3.6 first. <embarrassed grin>

The Vikings just lost and now I can't focus!

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Sunday, December 12, 2004 3: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