>I need to put a large number (approx 10 - 12 thousand) of RealAudio files and JPGs into a database. I figured i could either dump the files into memo fields or link to the actual files using OLE. Does anyone have any experience with the pro & cons of these methods? Or any better suggestions?
I agree with Wayne. Keep them in separate files. You'll find that your FPT file will grow out of control if you try to keep them in a table. It will also be more difficult to serve them up on the web.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer