saving external application files

  • Thread starter Thread starter rdmacaulay via AccessMonster.com
  • Start date Start date
R

rdmacaulay via AccessMonster.com

I have a front-end database that in addition to traditional database
processing I also allow the user to open a number of external application
documents: Excel, Windows Journal (Tablet PC), etc. My question is what is
the best way to prevent the user from changing the original document? I
would like them to save all their changes to a new document.
 
hi,
I have a front-end database that in addition to traditional database
processing I also allow the user to open a number of external application
documents: Excel, Windows Journal (Tablet PC), etc. My question is what is
the best way to prevent the user from changing the original document?
Click to expand...
Drop the user privileges (NTFS), so that they can only read the documents.


mfG
--> stefan <--
 
stefan said:
hi,

Drop the user privileges (NTFS), so that they can only read the documents.

mfG
--> stefan <--
Click to expand...

Thanks, Stephan.
Now I have some related questions: Can anyone provide code examples for the
best method of opening/saving/closing the external application documents: as
an example, I would like to open a new version of the document based on the
origonal doc. If the user closes the form that opened the external
application then I also want to close the external application and prompt the
user to save the document..
 
hi,
Now I have some related questions: Can anyone provide code examples for the
best method of opening/saving/closing the external application documents: as
an example, I would like to open a new version of the document based on the
origonal doc. If the user closes the form that opened the external
application then I also want to close the external application and prompt the
user to save the document..
Click to expand...
The problem here is how to detect if the user has finished editing, but
here is an Excel example:

Public Sub EditExcelFile(AOriginal As String, AEdit As String)
' AOriginal is the original Excel document including its path.
' AEdit is a temporary Name including an path
' where the user has write access.
' Error handling is missing.

Dim objExcel As Excel.Application

Name AOriginal As AEdit

Set objExcel = New Excel.Application

objExcel.Visible = True
objExcel.Workbooks.Open AEdit

End Sub


mfG
--> stefan <--
 
stefan said:
hi,
[quoted text clipped - 5 lines]
application then I also want to close the external application and prompt the
user to save the document..
Click to expand...
The problem here is how to detect if the user has finished editing, but
here is an Excel example:

Public Sub EditExcelFile(AOriginal As String, AEdit As String)
' AOriginal is the original Excel document including its path.
' AEdit is a temporary Name including an path
' where the user has write access.
' Error handling is missing.

Dim objExcel As Excel.Application

Name AOriginal As AEdit

Set objExcel = New Excel.Application

objExcel.Visible = True
objExcel.Workbooks.Open AEdit

End Sub

mfG
--> stefan <--
Click to expand...

Stefan,
Thanks, your code works but not quite as I expected - maybe I'm doing
something wrong but the original document is being deleted as the new doc is
created. Here's what I am trying to do: an exisiting document will be used
as a template to open a new document which the user can modify, name and save
to any location desired.
 
Back
Top