Attachments in Access - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Attachments in Access

Joseph Messina

5 years ago

Hi Richard:

I have question for yhou about something thqat I have in my SCAT Reservations database that i have to keep track of all my trips when nI use the bus. It is special transportation i se. On the tab control i have tab called documents and in the documents tab i have attachment field to attach the file document. When i get a receipt or when i give the driver my ticket for the fair i upload the receipts and tickets in my database for each trip I take. I want to know if that is okay to do that with documents. It is not attaching picturesa. Just PDF Files. Can you let me know how i can handle that or it is okay the ray i have it. If you want me to I can send you attachment of what i'm talking about. Can you please let me know?

	Richard Rost @Reply 5 years ago
Attachments of ANY kind (pictures or otherwise) are frowned upon. Access does not do well with other objects stored inside it. Read this. And this. I cover how to properly deal with storing documents WITH your database (not IN your database) in the Imaging Seminar and in the ABCD Part 5.

	Joseph Messina OP @Reply 5 years ago
Hi Richard: Thank you fo letting me know? I just wanted to know how to handle it. I remember you saying in one of your videos not to do tat wityh attachment.

	Richard Rost @Reply 5 years ago
Nope. Attachments are bad. Very bad. You can store the location of the file, but not the file itself.

	Joseph Messina OP @Reply 5 years ago
I truly i understand that they are bad to store in the database. I'm going to watch the ABCD video and do it like what is in the ABCD video. If i need help will ask someone for help

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View