Inserting OLE Object in Table via Form

pclutts

Registered User.
Local time
Today, 08:25
Joined
Aug 22, 2002
Messages
15
I have a field in a form where users go to insert an OLE Object via the right mouse button. The data type in the table is OLE Object. Prior to converting our 2003 database to 2007, this feature worked just fine using the right mouse button to select the particular file in question. Access 2007 doesn't allow this same procedure. I realize storing objects within a database causes it to be a larger file, but our office chose to do it that way regardless. I have read some about using the Attachment data type vs OLE Object data type. However, if I change the data type within the table, will all previously stored OLE Objects be deleted? Can anyone tell me how to take care of this problem? Thanks in advance for any advise.
 

Users who are viewing this thread

Back
Top Bottom