Access 2002 Error 3625 in converted database

[Roald Oines]

Hi,

I'm working on converting several of my Access 97 databases to Access
2002 format (the company's changing from NT 4 to XP and updating Office
at the same time), and this one has me stumped. As a performance
enhancer, I use VBA code (transfertext) to export the results of a query
(usually 20-30 thousand rows with a few dozen fields of customer
information) to the user's temp folder as a text file and then link to
it using a text file specification. Access 2002 is throwing error 3625
saying that the text file spec doesn't exist. I get this error if I try
to link to the text file manually using the wizard as well.

The spec *does* exist, it's in the MSYSImExSpecs table and its field
definitions are in the related msys table. If I'm using the wizard, I
click Advanced, select the spec from the list (indicates to me that the
spec exists!) and it only fails when I get to clicking the Finish
button. I even tried saving the spec to a different name and got the
same behavior.

I have another query/text file/link with similar data, of similar size
and that uses the same sub to run the transfertext that works fine in
the converted mdb. This one is the second.

I've googled groups and the web, looked in Access 2002 and 97's help
files and checked MS' support website and found no help for this issue.
Any ideas?

Thanks in advance.

--
Please remove the under_scores if sending me mail.

[Don Leverton]

Hi Ronald,

I suspect that this Access 2000 KB article might also apply to newer
versions as well?
http://support.microsoft.com/default...77&Product=acc

Don

"Roald Oines" <r_*******@bres nan.net> wrote in message
news:--*************** *****@bresnan.c om...

Hi,

I'm working on converting several of my Access 97 databases to Access
2002 format (the company's changing from NT 4 to XP and updating Office
at the same time), and this one has me stumped. As a performance
enhancer, I use VBA code (transfertext) to export the results of a query
(usually 20-30 thousand rows with a few dozen fields of customer
information) to the user's temp folder as a text file and then link to
it using a text file specification. Access 2002 is throwing error 3625
saying that the text file spec doesn't exist. I get this error if I try
to link to the text file manually using the wizard as well.

The spec *does* exist, it's in the MSYSImExSpecs table and its field
definitions are in the related msys table. If I'm using the wizard, I
click Advanced, select the spec from the list (indicates to me that the
spec exists!) and it only fails when I get to clicking the Finish
button. I even tried saving the spec to a different name and got the
same behavior.

I have another query/text file/link with similar data, of similar size
and that uses the same sub to run the transfertext that works fine in
the converted mdb. This one is the second.

I've googled groups and the web, looked in Access 2002 and 97's help
files and checked MS' support website and found no help for this issue.
Any ideas?

Thanks in advance.

--
Please remove the under_scores if sending me mail.

[Roald Oines]

Don Leverton (le************ ****@telusplane t.net) wrote:
: Hi Ronald,
:
: I suspect that this Access 2000 KB article might also apply to newer
: versions as well?
:
http://support.microsoft.com/default...77&Product=acc
:
: Don

Thanks, Don. I'll mess around with this at the office tomorrow -- but it
looks like they're saying the error occurs when you either 1) don't
specify the text specification or 2) try to use transfertext with a
schema.ini file. In my case, the VBA code includes the import spec,
Access sees the import spec (it's in the list of them when I try to link
manually using the import text wizard) but then it fails to use the
import spec and complains it's not there when attempting to link to it.
: "Roald Oines" <r_*******@bres nan.net> wrote in message
: news:--*************** *****@bresnan.c om...
:> Hi,
:>
:> I'm working on converting several of my Access 97 databases to Access
:> 2002 format (the company's changing from NT 4 to XP and updating
:> Office at the same time), and this one has me stumped. As a
:> performance enhancer, I use VBA code (transfertext) to export the
:> results of a query (usually 20-30 thousand rows with a few dozen
:> fields of customer information) to the user's temp folder as a text
:> file and then link to it using a text file specification. Access
:> 2002 is throwing error 3625 saying that the text file spec doesn't
:> exist. I get this error if I try to link to the text file manually
:> using the wizard as well.
:>
:> The spec *does* exist, it's in the MSYSImExSpecs table and its field
:> definitions are in the related msys table. If I'm using the wizard, I
:> click Advanced, select the spec from the list (indicates to me that
:> the spec exists!) and it only fails when I get to clicking the Finish
:> button. I even tried saving the spec to a different name and got the
:> same behavior.
:>
:> I have another query/text file/link with similar data, of similar
:> size and that uses the same sub to run the transfertext that works
:> fine in the converted mdb. This one is the second.
:>
:> I've googled groups and the web, looked in Access 2002 and 97's help
:> files and checked MS' support website and found no help for this
:> issue. Any ideas?
:>
:> Thanks in advance.
:>
:> --
:> Please remove the under_scores if sending me mail.

--
Please remove the under_scores if sending me mail.