Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 23rd, 2004, 04:39 AM
Dai14 Dai14 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2004
Posts: 1 Dai14 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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?

Reply With Quote
  #2  
Old April 27th, 2004, 12:57 AM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
 
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9
Send a message via ICQ to stumpy Send a message via MSN to stumpy
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.
__________________
DevArticles Moderator
BlueSix - Web Development and Consulting

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Extracting binary objects from Access


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway