[bonnie]

I'm using an Access Database, and there is a table for me to store the files. Of course the data type is "OLE Objects". But how can the page open this file after searching. Say for example, I want to search the file of 23 Jan,2003, after finished the searching, the file is opened immediately. What can I do?

[Tesco]

I 'm sorry, I don't understand what your trying to do. A little more explanation please?

[bonnie]

It means that there is a database to store all the files. It will base on the date to search the related file. After the file is found, the file will be open in the browser(no need to click any button).

[Tesco]

Yes, but what kind of file is it? Just a web page?

I prosume you have a search script already in place? If so, add this to the end of it:

Response.Redirect("" & rsName.Fields.Item("ColumnName") & "")

Of course, edit it to suit your needs. You'll need to change the bold parts for it to work. But, be careful, make sure you don't close the search recordset before using this code, if you do - it won't work.

[bonnie]

Thanks a lot!
Some PDF and Excel files.
But is there another way to do it?

[Tesco]

Ah, well, for those you need do it differently. IIRC you need open a data stream - but I have no experience with that You can try Google, but Shane will probably know what you need to do.

[bonnie]

Anyway, thanks a lot!!

[Shane]

If I understand you correctly, you are trying to load a binary file (XLS, PDF, DOC..etc) from an Access database and display it.

You really shouldn't store these types of files in Access. Sure, you can do it. It's possible, but it's not very reliable at all.

What I typically do is this:

- Setup your files table like this:

Code:

| ID | file_name |
---------------------

- When a user uploads a file, store the filename in the database and place the actual document in a folder that all of the documents will be located in.

- Now, when the user goes to the "Load Document" ASP page, just do a:

Code:

Response.Redirect("/documents/" & RS("file_name"))

Note: Replace the RS code with your actual Recordset object.

[bonnie]

I understand what you are doing. I cannot use "ID", since there is 5 years files in the database. We need to base on the date to search the specific file.

[Shane]

Well, how is your table setup?