Want table2 to automatically MIRROR table1, to include attachements

[Steven.Allman]

I currently use an update query after updating records to copy my changes to a mirror table on sharepoint. This isnt going to work with my attachments as there is no simple method to append or update query attachmnents, so is there a better method for creating a clone?
subtable work something like that?

[June7]

I don't know about Sharepoint table. It is possible to programmatically manipulate attachments. http://blogs.office.com/b/microsoft-...cess-2007.aspx

Several threads in this forum have discussed use of this code.

Alternative is to save the files externally and just have path in text field.

Embedded files can bloat a db and chew up file size limit of 2GB.

[Steven.Allman]

My database is split, and I acutally utilize several backends for different types of data. So far has proven very effecient.
Thus far, with 4000 records and maybe 3 dozen with attachments (new feature) that particular backend is only 16mb, so i have a long ways to go before I get insane. Most attachments are low res PDFs.
That code in particular is for saving the attachments, which I am having no trouble with. I can also manualy save the files on my sharepoint clone. Currently all information is saved to the clone automatically.
The easy method is to have all my info on sharepoint but with current structure, sharepoint doesnt like PK to be anything but autonumber, and I must use something else. I have many relationships and deleting a record from one table has deleted records from another with the shared relationship...
very annoying..

[June7]

The link I referenced has code to add attachment to a record, save attachment to folder, and remove attachment from record.

If you want to programmatically copy attachment from one record to another, will probably require combination of the first two procedures, that is if it's even possible with SharePoint.