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

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



More information about the AccessD mailing list