Press ads link via asp and a access database?

[budgy]

Hi Guys,

Really hope u can help me out here. I work for a organisation which has eletronic version of their press ads put on to their intranet system. These ads come in a regular basis, usually tons of them on a friday evening when i want to go home!.. What im trying to device is a system which will allow me to drop the pdf version of the press ads into a date base which in turn updates the connected asp page with the correct title and name of the publication. I have basic knowledge of access, but im pretty comfortable with asp. Can anyone offer any guildence or useful advise which will aid me?.... all ur suggestions will be most useful.

Thanks in advance!
"He that asks a question is a fool for a moment, he that never asks a question is a fool all his life"


"He that asks a question is a fool for a moment, he that never asks a question is a fool all his life

 

[Sheco]

It is often better to just put the file PATH into the database, rather than the entire binary file.

 

[budgy]

Hi Sheco thanks for that,

Yes that is my intention. TO include a path into the database which then calls upon the pdf files which i have detached and put into external folders. The main points for mem, is creating a ASP page which can read the datebase and display the page with the title of the publication and to which chain that ad belongs to. Im trying to make this imputting of press ads on the intranet has automated as possible. As of yet, its very laborious and time consuming. At the moment the ads arrannge by email and i have to individually link every ad and format the table on the press ads page to accomadate all the ads. Like always all the suggestions are appreciated.

Thanks!!

"He that asks a question is a fool for a moment, he that never asks a question is a fool all his life

 

[Sheco]

So you will have a database table.

The table will have fields like:

PubTitle
BelongsTo
DateCreated
FilePath
(whatever else you need)

...and you will use ADO to connect to your database and run SQL queries to select the rows of fields needed to dynamically build web pages...

Is this what you are doing?