[AccessD] Need to access EDI Audit Trail (Flat File) and Not Allow Updates

Stuart McLachlan stuart at lexacorp.com.pg
Mon Dec 3 10:57:28 CST 2012


Just a thought - do you need to ensure that IE is configured to display rather than download 
files with the log file's extension?

-- 
Stuart

On 4 Dec 2012 at 0:18, Darren wrote:

> Hi Brad
> 
> Create a form and drop an Internet Browser Control onto that form.
> Then open the form in run time and 'drag and drop' said file onto the
> Browser control.
> Should open the file and display it nicely - without edits.
> The file name can also be determined too, from the dragging and drop - very
> nice for dealing with file names etc.
> I'll send you a demo off-line - Lemme know if there are any "me toos"
> directly to my email and not to the list
> 
> darren
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Saturday, 1 December 2012 6:38 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Need to access EDI Audit Trail (Flat File) and Not
> Allow Updates
> 
> Stuart, Rusty, Jack,
> 
> Thanks for your ideas and insights.
> 
> For the near term, I am planning to employ a second (behind the scenes)
> file.
> 
> For the long term, I may use a linked table as I was finally able to get
> Access to treat the one large field as a memo field.
> 
> Another approach that I spent a little time on is to fire up Internet
> Explorer to display the flat file data as it cannot update the data in the
> file.
> 
> Thanks again for the help.
> 
> Brad
> 
>    
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge
> Sent: Thursday, November 29, 2012 3:13 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Need to access EDI Audit Trail (Flat File) and Not
> Allow Updates
> 
> Brad,, I don't really  know how to do what you're asking, but just thinking
> as I'm typing here--- Since anyone who wants to see the Log would only be
> interested in what is currently in the log (available up to the time they
> make a request), they really don't have a need to see the "Log file" per se.
> They could be shown a Read Only copy (from the instant they make the request
> so to speak) -- and leave the real Log for continued system/processing
> activity.
> 
> So if they were to get to the LogCopy, and alter the attributes from
> readOnly  and then alter some data-- they are still working with a copy.
> 
> I don't know if that helps, but does keep them from the "production/active"
> log.
> 
> Anyway, that and a $1.80 might get you a coffee..
> 
> Jack
> 
> On Thu, Nov 29, 2012 at 1:35 PM, Brad Marks
> <BradM at blackforestltd.com>wrote:
> 
> > All,
> >
> > We have an EDI application that has been built with Access 2007.  It 
> > works nicely.
> >
> > Recently there has been a request to add a new feature to the system 
> > that will allow the users to see the generated EDI audit trail file.
> > This is a flat file.
> >
> > I have added a button to the main form to open the Audit Trail file
> with
> > notepad.  This works fine, except that now there is a possibility that 
> > the users could accidentally change the data in this file.
> >
> > I don't think that I can set security to overcome this issue, because 
> > the EDI Application adds records to this Audit Trail file (behind the 
> > scenes).
> >
> > I thought that another possible solution would be to treat the Audit 
> > Trail file as Linked Table in Access.
> >
> > The catch is that the fields in the records are not delimited and the 
> > records can be over 256 bytes.
> >
> > Is there a way to tell Access to treat the records as one big memo 
> > field?
> >
> > Maybe there is another way to handle this situation.
> >
> > Thanks,
> > Brad
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list