mollyf@hotmail.com wrote in
news:1128374859.724364.131790@f14g2000cwb.googlegr oups.com:
[color=blue]
> Hello all--
>
> I'm working on a legacy Access 2000 application which imports
> a space delimited text file. There's a line of code:
>
> DoCmd.TransferText acImportFixed, "ClaimSpecsEDS",
> "ImportedClaims", Me!txtLocation
>
> which I know is importing the text file. From reading, I know
> that the "ClaimSpecsEDS" referred to in the line of code is
> the specification used since it's a space delimited file. Now
> my problem is that I need to modify the specification because
> the file is changing. I cannot find any file that's in the
> same directory as the database (which from everything I've
> read, the file should be in the same directory) but yet the
> application continues to work without a problem (even when
> moving it to another directory). The person who created this
> is no longer with the company.
>
> Does anyone have any suggestions as to what I can look for in
> order to access/modify the specification/schema without having
> to recreate it (I've already searched the drives looking for a
> file called ClaimSpecsEDS, I've looked through the code of the
> application to see if there's any reference in the code to a
> text file, etc.)?
>
> Thanks.
>
> Molly J. Fagan
> Oklahoma Foundation for Medical Quality
>[/color]
The 'file' you are looking for is really just a record in the
database. You will see it by doing a File->Import, change the
'files of type:' combo to textand selecting the file you wish to
import. This takes you to a popup menu. On that Menu there is an
'ADVANCED' button. The advanced button opens another menu which
has a button called specs.
As far as I know, you will have to recreate a new import
specification based on the new file format, then 'save as' using
the old (or a new) name. If you change the name, don't forget to
change the code.
--
Bob Quintal
PA is y I've altered my email address.
