[AccessD] Set references programmatically

The simplest approach would be to create a template database from
scratch and set the references you need.  Then just use a copy of that
as the container for the objects you export.  The references are part of
the database object.  You can set references in code, but it is a
finicky operation that I avoid like the plague. 

Actually, what you're doing sounds like a good candidate for partial
replication, although that has its own set of headaches.


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
ewaldt at gdls.com
Sent: Monday, July 24, 2006 5:16 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Set references programmatically


I create smaller databases from a main one so that I can send out the
smaller ones to users. I export forms, queries, and appropriate subsets
of tables. I also export a startup macro and a VBA function for the
startup macro to run. Now for the problem.

The VBA function uses DAO, and I need to make sure the user will have
DAO referred to. How do I do that programmatically? Specifically, I am
looking for "Microsoft DAO 3.6 Object Library".

TIA,

Thomas F. Ewald
FCS Database Manager
General Dynamics Land Systems
(586) 276-1256





This is an e-mail from General Dynamics Land Systems. It is for the
intended recipient only and may contain confidential and privileged
information.  No one else may read, print, store, copy, forward or act
in reliance on it or its attachments.  If you are not the intended
recipient, please return this message to the sender and delete the
message and any attachments from your computer. Your cooperation is
appreciated.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com