Please Help.-How do I allow users to insert attachments in Access2003?

[HockeyFan]

I created a table already and set the field property to ole object. I created the field on the form and set the control to the field in my table. Now how do I allow the user to insert an attachment? Please help.

 

[fneily]

I'd advise against storing the actual attachements in the database - it'll cause enormous bloat. Imagine storing encyclopedias for each record. Access 2007 allows it but I haven't tried it and observed the consequence.
What you would store is a hyperlink to the document or whatever.
If you really want to store an attachment in a table, then you can Blob it. See:
Storing BLOB data

http://www.databasedevelopment.co.uk/examples.htm

You can download an example of a database storing attachements as binary objects. This will minimize bloating of the database.

 

[HockeyFan]

thanks for the link. i was hoping to do it without so much coding, but i suppose if that's what i want to do, then i'll have to deal with it. Hey, at least i have examples now and don't have to code from scratch. thanks again for the reply.

 

[fneily]

You might also want to read the discussion found at:
thread702-1462519
thread702-1401973