how to attach file to access

J

John

I am a new Access user. I am creating a database where one of the input is
for the user to attach a file. I am not sure how to create that function
(browse button, add/load file...etc) in the form and add the file to the
database or as a field in the file. Can some one help?
 
J

John Vinson

I am a new Access user. I am creating a database where one of the input is
for the user to attach a file. I am not sure how to create that function
(browse button, add/load file...etc) in the form and add the file to the
database or as a field in the file. Can some one help?
Click to expand...

What kind of a "file"? You can (with some complexity) store Word
documents or Excel spreadsheets in an "OLE Object" field type, but
your database is likely to bloat very rapidly; there's a 2 GByte limit
to the overall database size that you might hit.

Could you perhaps simply store the filename and path, or a Hyperlink
to the file?

John W. Vinson[MVP]
 
J

John

Thanks for the reply.

I am creating a "issue" list database. One of the items that I like to have
attached as an input whenever someone creates a new issue is the e-mail from
the customer or a debugging report. The file will be short, and will not be
necessary for every issue. I just like to give the user an option of
attaching it to the particular issue rather than just having a link. Is this
possible?
 
J

John Vinson

Thanks for the reply.

I am creating a "issue" list database. One of the items that I like to have
attached as an input whenever someone creates a new issue is the e-mail from
the customer or a debugging report. The file will be short, and will not be
necessary for every issue. I just like to give the user an option of
attaching it to the particular issue rather than just having a link. Is this
possible?
Click to expand...

Again... you'll get an EMail. In Outlook, EMails are stored in the
Outlook .pst file, not as external files (though of course you can
export a message). What is the file type you intend to store? Would it
be suitable to store the *text* of the file (say in a Memo field) or
do you need to actually store a binary file such as a .msg file or a
Word .doc?

John W. Vinson[MVP]
 
J

John

The file type could be several things. .c, .h, and Matlab/Simulink model
files, and they could be binary or ascii files. I do have a field for like
"memo" for people to put in description. I don't believe the files will be
really big and not every issue will have an attachement. I like for the user
to upload the file (if any) that can be imported to the issue. That way over
time, we can find the attached file easily rather than just an link on hard
drive. Thank you for your help.
 
J

John Vinson

The file type could be several things. .c, .h, and Matlab/Simulink model
files, and they could be binary or ascii files. I do have a field for like
"memo" for people to put in description. I don't believe the files will be
really big and not every issue will have an attachement. I like for the user
to upload the file (if any) that can be imported to the issue. That way over
time, we can find the attached file easily rather than just an link on hard
drive. Thank you for your help.
Click to expand...

I'd suggest you repost then - the file would need to go into an OLE
Object field, but that's not a feature of Access which I've used, and
I am not confident at giving you advice.

If you post a new thread with REPOST in the subject line, I'll leave
it alone and let someone more knowledgable help - sorry about that!

John W. Vinson[MVP]
 
Top