Assign the datata type

[Tim]

I have .rtf files and .wav files that I want to save in an Access table. What
kind of datatype should I assign to the .rtf files and .wav files? Can I use
recordset(s) and loop(s) to go through all these fields that contain these
files and manipulate them? I am afraid that they are too big.
Any advice would be greatly appreciated.
Thank you,

 

[Jeff Boyce]

Tim

Access has proven susceptible to "bloat" when you store OLE-type data
(binary large objects - blobs). If you can use SQL-Server as a back-end
data store, storing blobs is not such an issue.

If you need to use Access, I believe the consensus approach to your
situation is to NOT store the blobs, but rather, to store "pointers" to the
files, which you store in folders in Windows.

 

[Tim]

Hi Jeff:
Thank you very much for your advice. Now if I use SQL Server 2K to store
those values then is it possible to use recordset(s) and loop(s) to go
through all these fields that contain these files and manipulate them?

Thank you again.

 

[Jeff Boyce]

I'm not sure what you want to do with those. The .rtfs seem amenable to
"manipulation" via Word. I don't know what app you'd use to manipulate the
..wav files.

One app I've set up sticks .pdf files into SQL-Server and retrieves them,
launching Adobe Reader.

Define "manipulate". And I don't understand looping through recordsets of
blobs. What are you doing with them?

 

[Tim]

I have many .rtf files and .wav files that are stored on the computer. Those
..rtf files are test files and .wav files are sound files corresponding with
those rtf files. It is similiar to a foreign language test with the voice.
These files are used locally. Now I would like to create a web program so
people can use on the internet. I have two ideas to deal with this web
stuff. The first one is stored those files into a SQL Server table and use
VBScript (ASP) to write code to connect to the database, create recordsets,
open those files for reading, score the result, etc. The second idea is I
just save those files on the server and use VBScript's FileSystemObject to
access to the files.
Do you know which way is better?
Thanks,

 

[Jeff Boyce]

Sorry, no experience in that arena.

Good luck!

Jeff Boyce
<Office/Access MVP>