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

Have you tried linking it as a fixed width text file and specify one
field with a width of 999?

Rusty

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, November 29, 2012 12:35 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Need to access EDI Audit Trail (Flat File) and Not
AllowUpdates

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
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************