 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / February 2006saving external application files
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? Drop the user privileges (NTFS), so that they can only read the documents. mfG --> stefan <-- >hi, > [quoted text clipped - 6 lines] >mfG >--> stefan <-- 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, >>> My question is what is >>> the best way to prevent the user from changing the original document? [quoted text clipped - 5 lines] > application then I also want to close the external application and prompt the > user to save the document.. 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 <-- >hi, > [quoted text clipped - 25 lines] >mfG >--> stefan <-- 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.