Edit Word OLE object

[JensB]

This might be a question between more groups, but I hope someone know how to
deal with it.

I got a lot of Word documents stored in an Access database, as OLE Objects,
and retrieve them by vb.net
when a user select some items on UI, the related WORD text(object) in the
database is placed by
copy paste to a temporary document, and from there to the new main document,
done by vb.net code.
So far so good.

As a developer I just edit the OLE-Object by double-clicking on the
database cell, and words open, I can then edit the document.
After editing , open menu File and select "Close and return to myTablename",
and my newly edited text are saved.

My question is how to enable an admin user, to maintain text changes in the
database, not accessing it directly, but using vb.net?
Users should not have un-controlled access to the database, as it contain
several coloums with different languages,
and the admin should only have access to his own country language.
the database is therefore secured with a workgroupfile.
I know how to retrieve to Ole-Object in vb.net, but not how place them back
again.



Jens

 

[Cindy M -WordMVP-]

Hi JensB,

You need to begin with this in an ACCESS newsgroup, as your first concern is
allowing only certain users access to certain information. As far as I know,
Access has no concept of Windows security, so on its own it can't distinguish
whether someone is an "admin".

Up through Access 2003, it has its own security/permissions, but these have to
be assigned explicitly. Possibly, someone in an Access group will have an idea
how granting rights can be done "on-the-fly", through the Access automation
interface or possibly through ADO or DAO.

If the object is opening in its own application window (not embedded in
Access), then try oleDocObjectVariable.Application.Quit wdDoNotSaveChanges

This might be a question between more groups, but I hope someone know how to
deal with it.

I got a lot of Word documents stored in an Access database, as OLE Objects,
and retrieve them by vb.net
when a user select some items on UI, the related WORD text(object) in the
database is placed by
copy paste to a temporary document, and from there to the new main document,
done by vb.net code.
So far so good.

As a developer I just edit the OLE-Object by double-clicking on the
database cell, and words open, I can then edit the document.
After editing , open menu File and select "Close and return to myTablename",
and my newly edited text are saved.

My question is how to enable an admin user, to maintain text changes in the
database, not accessing it directly, but using vb.net?
Users should not have un-controlled access to the database, as it contain
several coloums with different languages,
and the admin should only have access to his own country language.
the database is therefore secured with a workgroupfile.
I know how to retrieve to Ole-Object in vb.net, but not how place them back
again.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail