By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

Want to easily copy selected object between databases

P: n/a
I have an Access application front end that has a generic version and
several versions that I have customized for clients with small changes
to various objects. Every few months I make improvements the the
generic version. I am looking for an easy way to move the customized
customized objects into the geeneric version.

If the customizations are unique I just name them in ways that reflect
the customers name to make them easy to import. For example a query or
report for customer 'xyz' might be called 'xyz_SummaryData'. This
presents no problems.

Things get tricky when I have modified a form or query that everyone
uses. For example I might have extra fields, controls, or VBA code in
a basic client information form that is unique to a customer. Is there
a way to automatically copy objects in a that have been put into an
object group or with a particular object tag to another Access
database (either export from one or import into the other).

I have had no luck working with the "Groups" part of the database
window - I had a fantasy that I could drag the "Group" objects from
one database to the other. Is there a way to work with a "Group"
programmatically? If not, I am hoping there is a way to cycle through
the Forms, Reports, etc. examine the 'tag' property, and export them
into the other database. Is this a reasonable strategy? Is there a
better approach?

Thanks in advance!
Jim Mandala
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.