copy of MsysIMEXSpecs And MSysIMEXColumns and other import/output problems

[odrap]

1)In Ms Access2007 the systemtables MSysIMEXSpecs and MSysIMEXColumns contains the necessary data for the saved import- and exportspecifications. Is it possible by importing these tables from one database to another, to have the same import- and exportspecifications in both databases?
2)After creating an import or export specification, we can save these import / export steps by specifying that in the import/export wizard. In such a case a name must be given for the import-/ exportspecification.
Why isn't it possible to use this name as import/export specification in a code as the one below:
DoCmd.TransferText acExportDelim, "name of the exportspecification", "tblTeVerzendenOrders", "C:\DW\Verzenden\tblTeVerzendenOrders.txt", True
3) By using the method :
DoCmd.SendObject acSendTable, "tblTeVerzendenOrders", acFormatHTML, "emailddress" , , "Geboekte Orders", "Orders geboekt op " & Format(Date, "dd/mmmm/yyyy"), True i can send this object as a HTML document via a attachment of a email in MS Outlook Express edition.
This way i don't need to have the full blown MS OUTLOOK.
But on the site of the receiver, how can i extract this attachment from the email and importing it back in a ms Access datatable without the need to have MS OUTLOOK?

 

[nIGHTmAYOR]

Woo Woo Woo , where are you heading with that horse ?
First of all what are you trying to achieve ? Replication ? If so could you use Virtual Private Network and Sync both dbs ? Or is it something more secure , then why wouldnt you send a saved setting table that you custom create and then have this table processed through VBA to apply the certain database settings apon recieve on the other side ? cz technicaly this is how things are done in Microsoft Access System Tables.
Second how are you using Outlook to process attachments that you are tired and long for to replace ? Outlook db doesn't authorize the quering of attachments! On the other hand Microsoft Exchange does and in that case you can extract / connect / import data in need to process , now you can search this forum on how to use Microsoft Exchange in data transfer.

 

[dfenton]

First of all what are you trying to achieve ? Replication ? If so could you use Virtual Private Network and Sync both dbs ?

For replication you need a lot more than a VPN. A VPN gets you nowhere without indirect or Internet replication. Direct replication is suitable only on a wired LAN -- nowhere else.