Attaching PDf to record

[Dr_Worm]

Hi

Running Access 97 on Windows 98 (Will be upgrading to XP when management gives approval )

I've got a database with an OLE field, and one of my workmate's needs to attach PDF's to it. When he first attaches the file, he can open it without a problem, but if he closes Access and then opens it again he gets a message saying Acrobat not registered, try reinstalling the program to register.

The reason we are using PDF format is because the document is signed by an employee, scanned, and attached to their record.

Is there a better way of doing this process?

Origionally they were Excel files, but because the signature is needed that doesn't work, and JPEG/GIF are to big and slow the database too much.

Any suggestions would be greatly appreciated

 

[SydneyGeek]

Have you tried using a Hyperlink field? In DATASHEET view in the desired table, select the column to the right of where you want the hyperlink field to go. Insert | Hyperlink field, and follow the prompts.

Denis