Hi all,

I hope you can help me with this one.

I have got 2 database files which i open in one workspace. The 2nd
database holds a table which holds a hole host of embedded documents.
What i am tring to do is from my 1st database, have a form which asks
for a document name and description and number etc. and then when the
user clicks on a button "Add File" it gets an OLE object. Once all
the information is specified the user can then click "Save" and this
will then put all the data into the table in the second database.

So far i have managed to save all the data into the second table with
the exception of the OLE Object. I have a field called "Attachment"
in the second databases table "Documents", which i can manually insert
an OLE object into. But i have had no success in inserting from my
form.

I have

Dim OLEAttachment as ObjectFrame

As a global

Then in the onclick of the button i try to assign an OLE object to it
by

OLEAttachment.OLETypeAllowed = acOLEEmbedded

and then i go on to get the Prompt for file location. It however
falls over at the TypeAllowed stage saying that there is no object

Many thanks in advance for any help
--
Dave

In general, its not a good idea to try to store BLOB (Binary Large OBject
http://www.webopedia.com/TERM/B/BLOB.html) data in an Access database. This
will cause the size of the database to bloat beyond reason. A better
alternative, in my opinion, is to store a hyperlink to the object instead of
trying to store the actual object. I have a sample Access 97 database
available that I can send to you, if you'd like to see how this is done. It
easily converts to the Access 2000 format. Send a reply to me (not to the
group) if you'd like a copy. Note that my apparent e-mail address includes
extra text that you'll need to remove, which serves as some protection
against those nasty spammers.

If you are intent on storing BLOBs, here is a MSKB article titled "Reading,
Storing, and Writing Binary Large Objects (BLOBs)" that might be helpful for
you:
http://support.microsoft.com/default...b;en-us;210486

_______________________________________

"Dave P" <dave (AT) chingenterprises (DOT) com> wrote

Hi all,

I hope you can help me with this one.

I have got 2 database files which i open in one workspace. The 2nd
database holds a table which holds a hole host of embedded documents.
What i am tring to do is from my 1st database, have a form which asks
for a document name and description and number etc. and then when the
user clicks on a button "Add File" it gets an OLE object. Once all
the information is specified the user can then click "Save" and this
will then put all the data into the table in the second database.

So far i have managed to save all the data into the second table with
the exception of the OLE Object. I have a field called "Attachment"
in the second databases table "Documents", which i can manually insert
an OLE object into. But i have had no success in inserting from my
form.

I have

Dim OLEAttachment as ObjectFrame

As a global

Then in the onclick of the button i try to assign an OLE object to it
by

OLEAttachment.OLETypeAllowed = acOLEEmbedded

and then i go on to get the Prompt for file location. It however
falls over at the TypeAllowed stage saying that there is no object

Many thanks in advance for any help
--
Dave