Computing.Net > Forums > Database > attaching files/linking in access

attaching files/linking in access

Reply to Message Icon

Original Message
Name: chaft
Date: September 21, 2007 at 09:06:40 Pacific
Subject: attaching files/linking in access
OS: xp pro
CPU/Ram: 2gb
Model/Manufacturer: hp
Comment:

I want to attach my purchase order files (microsoft word 2003 files) to records in my access database. Is it possible to link or better store them in the access? I want to be able to go to the record and be able to the record and see the Purchase order documents. Then be able to open them. Each record will have different files attached. Any ideas, because if i can do something like this it would be very exciting.
If there could be a drag and drop funtion i'd be gurgling with glee....but hey i'm opne to the simplest solutions first and foremost. ideas suggestions comments?


Report Offensive Message For Removal


Response Number 1
Name: Jennifer SUMN
Date: September 21, 2007 at 19:35:01 Pacific
Subject: attaching files/linking in access
Reply: (edit)

One way is to Insert a Hyperlink field in your table. Then insert the Hyperlink to the Document.

Life's more painless for the brainless.


Report Offensive Follow Up For Removal

Response Number 2
Name: chaft
Date: September 24, 2007 at 09:06:46 Pacific
Subject: attaching files/linking in access
Reply: (edit)

true..is there another way too? thanks for your help. I'm just trying to weigh up the options? Is there a more fancy way?


Report Offensive Follow Up For Removal

Response Number 3
Name: Jennifer SUMN
Date: September 24, 2007 at 14:41:02 Pacific
Subject: attaching files/linking in access
Reply: (edit)

What do you mean by "fancy?" You asked for the simplest way to attach a document.. Perhaps you can clarify what exactly it is that you want.


Life's more painless for the brainless.


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: attaching files/linking in access

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




How often do you use Computing.Net?

Every Day
Once a Week
Once a Month
This Is My First Time!


View Results

Poll Finishes In 2 Days.
Discuss in The Lounge