T
Toxalot
Using Access 2003 on WinXP
I want to export several queries to tables in an external database.
I found info about SELECT INTO and DoCmd.TransferDatabase and they
work great to export a subset of the data. The problem is that I
really want the exported data to maintain the relationships, indexes,
and properties, etc.
What is the best way to achieve this? Should I export the data another
way? Or use the above and create the relationships, indexes, and
properties, etc. after export? I would also have to delete the
relationships before exporting as I discovered that
DoCmd.TransferDatabase won't replace a table that is used in a
relationship.
How can I set the relationships, indexes, and properties, etc. through
VBA?
Can I count on certain default field properties? Or should I be
setting every single one?
Can I copy the relationships, indexes, and properties from the source
tables or do I have to hard code it all?
Jennifer
I want to export several queries to tables in an external database.
I found info about SELECT INTO and DoCmd.TransferDatabase and they
work great to export a subset of the data. The problem is that I
really want the exported data to maintain the relationships, indexes,
and properties, etc.
What is the best way to achieve this? Should I export the data another
way? Or use the above and create the relationships, indexes, and
properties, etc. after export? I would also have to delete the
relationships before exporting as I discovered that
DoCmd.TransferDatabase won't replace a table that is used in a
relationship.
How can I set the relationships, indexes, and properties, etc. through
VBA?
Can I count on certain default field properties? Or should I be
setting every single one?
Can I copy the relationships, indexes, and properties from the source
tables or do I have to hard code it all?
Jennifer