Darren
darren at activebilling.com.au
Mon Dec 3 16:26:53 CST 2012
Hi Rocky I'm using Access 2002 and I have it D -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, 4 December 2012 12:39 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need to access EDI Audit Trail (Flat File)andNot Allow Updates Is the internet browser control available only in 2010 or also in 2007 and 2003? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Monday, December 03, 2012 5:23 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Need to access EDI Audit Trail (Flat File)andNot Allow Updates Darren, Thanks for your ideas and your offer to send a demo. I think that your approach will work nicely for the issue that I am dealing with and it will also be helpful for future use in other situations. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Darren Sent: Mon 12/3/2012 7:18 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need to access EDI Audit Trail (Flat File) andNot Allow Updates 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 -- 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