From: PLAMEN HRISTOV on

De: "sk" <sk(a)discussions.microsoft.com>
Asunto: RE: A few Attachment questions
Fecha: jueves, 18 de febrero de 2010 12:00

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

"Daniel Pineault" wrote:

> 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" wrote:
>
> > 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