A general query which I don't seem to be able to get much information on.

When you attempt to add a word document as an OLE object into an access table, if the document is password protected, you are asked for the password and the protection is removed in the embedded object. (I imagine linking would not be a problem)

It is also not possible to add a password to a document that is already embedded (in tools --> options --> Save)

Is there anyway to retain the password protection on the file?

Why is it removed by default?

I what to be prompted for the password every time I open the embedded object.

Thanks

First of all, do not use tha field type on any database. Save the path to the file in a field instead and opend the file using the hyperlink control. To secure the file, use Windows security on the folder where the files reside.



Sal

Thanks Sal,But I want to store the objects, they need to reside within the database, as I said, I assumed linking would not be a problem, and that the problem most probably resides in the formatting of the object when it is embedded.

Anyone have any ideas?

Why do they need to be inside of the database? Access can not handle too much data as it is. Putting images inside of the database will corrupt your database if it is being shared in a network.



Sal

Sal,

Although this is not my question.....

Embedding documents in an access table has the following advantages:-

-Greater portability (where the db goes, the files go..)
-Better performance (In some instances) because the file is local
- The same security that protects data within your Access DB can be applied to embedded objects.

I agree that "Access can not handle too much data as it is" but as long as it's controlled and monitored, this is quite acceptable.