Transfertext Fails

[Gary]

I've written an application that works fine on 3 machines
but fails on a 4th. Investigation has show that the
DoCmd.TransferText is failing with the error "Could Not
Delete From Specified Tables".
The Transfertext function is being used to import a text
file (in CSV format) into an existing table which has just
been emptied.
Any ideas what the problem might be?

 

[Dale Fye]

It looks like your attempt to 'empty' the existing table has failed.

Does that table have any relationships to other tables with
referential integrity set. Are you sure tht the version of the
program on the 4 systems is the same and that they are all running the
same version/SR of Access and Windows?

--
HTH

Dale Fye


I've written an application that works fine on 3 machines
but fails on a 4th. Investigation has show that the
DoCmd.TransferText is failing with the error "Could Not
Delete From Specified Tables".
The Transfertext function is being used to import a text
file (in CSV format) into an existing table which has just
been emptied.
Any ideas what the problem might be?

 

[Gary]

The table don't have any referential integrity. The
database is dead simple and only has two tables. All the
application does is read in a CSV file into a table, makes
calls to a Sybase database to look up some customer data
which it stores in a second table and then writes this
second table out into another CSV file.

I think the delete worked, because on the machine where I
have the problem I stepped it through and it fell over on
the transfertext and not on the Delete query.

The machines should all be running the same version of
Access, but two have Windows 2000 and two have Windows
98. It is one of the Windows 98 machines that is giving
me trouble.

They all have the same version of my application.
One other point that I did not mention though, the
application used to work fine on the 4th PC, but the user
recently had Windows 98 re-installed and since then this
application has not worked.

Gary