467,886 Members | 1,795 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,886 developers. It's quick & easy.

Help with schema.ini file

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

Nov 13 '05 #1
  • viewed: 9355
Share:
3 Replies
mo****@hotmail.com wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
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

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.
Nov 13 '05 #2
jv
You can access the specifications from the text import/export wizard.
To get there, click on File, Get External Data, Import, select the text
file you want to import. Once the Import Text Wizard window appear,
click on Advanced. In the next window, click on Specs. Then you'll be
able to see the list of existing specs and select the one you want to
modify.

Nov 13 '05 #3
Thank you Bob and jv--I found what I was looking for.
Molly J. Fagan
Oklahoma Foundation for Medical Quality

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Vagabond Software | last post: by
4 posts views Thread by Iain A. Mcleod | last post: by
1 post views Thread by Rajender | last post: by
reply views Thread by comic_rage | last post: by
reply views Thread by wb5plj | last post: by
1 post views Thread by =?Utf-8?B?VGVycmFuY2U=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.