By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Programmactically Embeeded Word Doc into OLE Object

P: n/a
I've searched Google for a couple of hours and I did not find an
answer to my question. Thanks for your interest!

Is there a way to update a table with a new(updated) word Document? I
can do this internally to Access but I need an ASP web page to update
the word document then allow the user to download the Access database.
got any suggestion?

Thanks again
N. Graves
Nov 27 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 27 Nov 2006 17:02:52 -0600, N. Graves
<ng*****@REMOVEyahoo.comwrote:

Since you already know how to do this internally to Access (I assume
you mean "programmatically in Access"), then just invoke that routine
any time Access (running on the server) sees a new document in the
Upload folder.

-Tom.
>I've searched Google for a couple of hours and I did not find an
answer to my question. Thanks for your interest!

Is there a way to update a table with a new(updated) word Document? I
can do this internally to Access but I need an ASP web page to update
the word document then allow the user to download the Access database.
got any suggestion?

Thanks again
N. Graves
Nov 28 '06 #2

P: n/a
Tom Thanks for your response!

Yea, I can do that but the real issue that I have is that I need the
document that I will be updating to be secure... so only the users
that are using this access database can see it. With that said they
all database users would have to access to the server where the
document resides and I want to force the to access the document from
the database.

I'm currently update most of the tables in the Access database with
data from a SQL database and I it works perfectly. I was thinking
that if I could write some more VB code in the ASP page that would
update the embedded document then I could control the access to the
document. That is where I'm coming up short.
On Mon, 27 Nov 2006 19:28:03 -0700, Tom van Stiphout
<no*************@cox.netwrote:
>On Mon, 27 Nov 2006 17:02:52 -0600, N. Graves
<ng*****@REMOVEyahoo.comwrote:

Since you already know how to do this internally to Access (I assume
you mean "programmatically in Access"), then just invoke that routine
any time Access (running on the server) sees a new document in the
Upload folder.

-Tom.
>>I've searched Google for a couple of hours and I did not find an
answer to my question. Thanks for your interest!

Is there a way to update a table with a new(updated) word Document? I
can do this internally to Access but I need an ASP web page to update
the word document then allow the user to download the Access database.
got any suggestion?

Thanks again
N. Graves
Nov 28 '06 #3

P: n/a
On Mon, 27 Nov 2006 21:15:58 -0600, N. Graves
<ng*****@REMOVEyahoo.comwrote:

In your ASP upload page, you can certainly upload to a folder outside
of web root, that the average websurfer can't get to.

You can also reconsider the use of embedded objects, and rather store
the (relative) path to the documents in a text field, and keep the
documents in the file system.

-Tom.
>Tom Thanks for your response!

Yea, I can do that but the real issue that I have is that I need the
document that I will be updating to be secure... so only the users
that are using this access database can see it. With that said they
all database users would have to access to the server where the
document resides and I want to force the to access the document from
the database.

I'm currently update most of the tables in the Access database with
data from a SQL database and I it works perfectly. I was thinking
that if I could write some more VB code in the ASP page that would
update the embedded document then I could control the access to the
document. That is where I'm coming up short.
On Mon, 27 Nov 2006 19:28:03 -0700, Tom van Stiphout
<no*************@cox.netwrote:
>>On Mon, 27 Nov 2006 17:02:52 -0600, N. Graves
<ng*****@REMOVEyahoo.comwrote:

Since you already know how to do this internally to Access (I assume
you mean "programmatically in Access"), then just invoke that routine
any time Access (running on the server) sees a new document in the
Upload folder.

-Tom.
>>>I've searched Google for a couple of hours and I did not find an
answer to my question. Thanks for your interest!

Is there a way to update a table with a new(updated) word Document? I
can do this internally to Access but I need an ASP web page to update
the word document then allow the user to download the Access database.
got any suggestion?

Thanks again
N. Graves
Nov 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.