|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Extracting binary objects from Access
I have built a sports analysis db in MS Access that uses the object field to store avi movie files, shot using a DV camera. I intend for the db to be uploaded onto a server using asp, so that it could be viewed on a PDA.
However, every time that I try to export the tables, etc out of MS Access as asp, the newly created asp files fail to create the object field – within which the avi files are stored. Does anybody know how to overcome this problem, so that I can playback the avi files, with the db exported as asp? |
|
#2
|
||||
|
||||
|
What do you mean by "exporting the tables to ASP"... doesn't make sense. ASP is just for coding webpages - not data storage. So, in your case, you'd call the queries in the MS Access DB sitting on the webserver. You will need to write some special code to get the AVI movies out. Binary objects in a DB are called BLOB's. There are a lot of resources on the net about extracting BLOB's using ASP. I have posted some code which shows how to write a binary stream to a browser in this forum.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Extracting binary objects from Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|