OLE

A

amy

Is it possible to put a descriptive text in a field
designated for OLE? For example, all my entries in the
OLE field say "Adobe Acrobat Document" and i would like to
describe each document in that space.
 
J

John Nurick

Hi Amy,

No, it's not possible (or rather, it's theoretically possible but
prohibitively difficult).

Instead, add a text field to your table and store the descriptions in
that.

If you need to store more than a few documents in your database you're
likely to find that the size of the MDB file bloats out of all
proportion. Often, the best approach is to store the documents as files
on the disk and just keep their names and locations in a text field in
the database. Arvin Meyer's DocMgr sample database here
http://www.datastrat.com/DataStrat2.html
shows the techniques for managing documents as external files.
 
A

amy

i was afraid that was the answer! thank you so much for
taking the time to reply!!

regards,
amy
-----Original Message-----
Hi Amy,

No, it's not possible (or rather, it's theoretically possible but
prohibitively difficult).

Instead, add a text field to your table and store the descriptions in
that.

If you need to store more than a few documents in your database you're
likely to find that the size of the MDB file bloats out of all
proportion. Often, the best approach is to store the documents as files
on the disk and just keep their names and locations in a text field in
the database. Arvin Meyer's DocMgr sample database here
http://www.datastrat.com/DataStrat2.html
shows the techniques for managing documents as external files.
Is it possible to put a descriptive text in a field
designated for OLE? For example, all my entries in the
OLE field say "Adobe Acrobat Document" and i would like to
describe each document in that space.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top