Question Help me: a problem in OLE OBJECT

[radoinrara]

Hello Guys.
I have a .mdb file (AC-97) that contains a column with an OLE object format.
When I want to open it to see its contents I keep getting an error.
I tried to export the .bin file of the column but i did not understand what i do with the file.
Can you help me open the contents of this column,and do sum change on it,using a forms or modules
The file in the attachment.
Help me please and thank you.​

 

[sneuberg]

What error are you getting? OLE file are associated with some application. If your system doesn't have that application you won't be able to view it. If you don't know what it is I suggestion trying http://www.solvusoft.com/en/file-extensions/file-extension-ole/

If you try that please let me know how it went.

I'd try it myself but I can't open the database you posted on my system. I have Access 2013 and when I try to open it it complains about being a previous version.

 

[radoinrara]

Thank you for replaying
I cant find the extension of the file
I have attach to you a photo of the error and the file how be open in access 2013
thank you for helping me​

 

[sneuberg]

First I don't get the error when I look at the table Test in the TEST2.mdb you posted. It shows "Long Binary Data" in the logo field. I exported the data in the field using this code I found on line.

Public Sub Test()

Dim stmFileStream As ADODB.Stream
Dim RS As New ADODB.Recordset
Set stmFileStream = New ADODB.Stream
RS.Open "Test", CurrentProject.Connection
With stmFileStream
     .Open
     .Type = adTypeBinary
     .Write RS![Logo]
     .SaveToFile "Z:\TestFile"
     .Close
End With
Set RS = Nothing
Set stmFileStream = Nothing

End Sub

The resulting file is only 344 bytes. I looked at it with a hex editor, but that told me nothing. I also used that link I posted and that didn't tell me anything either.

With a size of 344 bytes it couldn't have been much of an object. I wonder if it didn't get corrupted.

 

[CJ_London]

I have a .mdb file (AC-97)

the file how be open in access 2013

see this link
https://support.office.com/en-US/ar...ess-2013-BC006FC3-5B48-499E-8C7D-9A2DFEF68E2F

In particular

Access support of Jet 3.x IISAM
You can no longer open an Access 97 database in Access 2013. You'll need to upgrade the file. To do this, open it in Access 2010 or Access 2007, save it in the .accdb file format, and then open it in Access 2013.
This change also affects databases that are linked to Access 97 databases.
ACCDB is the recommended format for desktop databases.
Open the Access 97 database file in a version of Access later than Access 97 but earlier than Access 2013, and convert it to a version no earlier than Access 2000. Access 2013 supports Access 2000 and later versions, through Access 2010.
Removing support because the Jet 3.x IISAM driver is no longer available.

 

[radoinrara]

thank you Guys for helping.
i can now read the binary data.
can you tell me how to import the binary file to the column and thanks.

 

[sneuberg]

The site https://bytes.com/topic/access/answers/745047-how-export-out-ole-object-content-folder-c-temp where I got the code to export the field also has code that shows how to import. You just need to add code to open the record set as I did, but why do you want to do that if you don't know what this data is?

 

[radoinrara]

thank you for helping me .
I have the programme how is made to decode this binary data.
but i cant understand where i have to put the code that you had give me(in macro or mudule) .
if you can upload to me the all the fille whith the code.
and thanks.

 

[sneuberg]

The code that exports the long binary field is in the attached database in the module named Output OLE Object. To use this you have to change the .SaveToFile location to somewhere on your system. To run the code you can just place the cursor somewhere in the subroutine code and press F5

This code uses the Microsoft Active Data Objects Library reference. If this code does not compile on your system check that reference.