Databases and Text Files

I have an asp web page that allows a user to request information from an Access Database, the results of this request are then displayed on a second asp web page and finally the user can then select to view the individual results of the request on a third asp page.

For instance, a user can select all the registered names beginning with the letter 'A', the result of this request will be shown on page2.asp, the user can then select one of the names and the results of that request will be shown on page3.asp.

What I want to happen now is that on page3.asp I need to display some text, the amount of text is too long to put it directly in the Access Database, it needs to be in a separate file like a txt file or something. I need to know how to set up the field on the Access Database to call the text file and the asp code I need to use on page3.asp.

Any suggestions?

Pretty similar to the image post you made. Store a path to the file in the database as a text field and use the FileSystemObject to read/write to that file from your page.

Yeah I know, I've had some suggestions for creating a memo field in my Database but I prefer your method, my Database is going to be big enough as it is.

Thanks Catalyst