I am in the middle of designing/improving our database with access xp on the front end and sql server 2000 as the engine. Let me give you an idea of what we have so far. The database has a form which the users enter data into and in this form theres is a link to the Scanned PDF documents which reside on our server. Now the users can click on the link to see the PDF documents but I would like for them to be able to preview the documents on a seperate form which also resides in the database. I just them to be able to preview each document for each record on a form in the database (the form would be called Preview Pane). Is there a way I can do this and how???

Thank you everyone