A few Attachment questions

[sk]

I have never worked with attachments so....

I'm making a multi-user db (FE-BE) and am worried about attachements causing
the BE to get to large.

Can I split the attachements to a different table in a second BE db? If so,
how do I code the Attachment control to add the attachement to a new record
in the table. I can get it to work on an existing record when the form is
bound to a table but when I don't have the control bound to a specific
table/field in the db, the control is inactive.

What I want to happen is if the user has a file to attach, they can drop it
on the control, and the system will create the new record associated with the
item the attachement is related to. (in a second db if needed)

thanks

 

[Daniel Pineault]

What version of access are you working with.

The process is very different for Pre 2007 from post 2007
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[sk]

I'm using 2007, sorry about leaving that part out.

 

[sk]

Anybody? I still can not figure it out.

Thanks

I'm using 2007, sorry about leaving that part out.