[AccessD] TransferText working sporadically.

MartyConnelly martyconnelly at shaw.ca
Fri Apr 30 12:15:47 CDT 2004


ACC2000: How to Import a Text File That Has an Extension That Access 
Does Not Recognize
http://support.microsoft.com/default.aspx?scid=kb;en-us;306144&Product=acc
Also check the registry key for disabled extensions on both machines as 
per above

DWUTKA at marlow.com wrote:

>Abra was upgraded to a newer version of Foxpro.  but I don't see how that
>would affect the TransferText funtion from importing a text file into Abra.
>He is going to try it from a Windows 2000 machine, to see if it's a quirk
>with NT 4.0.
>
>Drew
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Lawrence
>(AccessD)
>Sent: Friday, April 30, 2004 11:24 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] TransferText working sporadically.
>
>
>Hi Drew:
>
>I have no specific knowledge of your site but as an outside observer this
>would be my approach:
>
>If it was a user I would ask (suspiciously, I might add) has there been any
>recent upgrades to the computers in question. (The answer is of course
>always, NO.)
>
>The problem might be with Abra...has it reach the 2 GB limit? (A lot of
>older databases had that limitation not just Access)
>
>If your accessing works fine maybe the Payroll guy is running some
>procedures that you are not?
>
>Is the Payroll guy using a different FE? if so maybe an update is warranted.
>
>This is a few of the questions I would check out.
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
>DWUTKA at marlow.com
>Sent: Thursday, April 29, 2004 11:00 AM
>To: AccessD at databaseadvisors.com
>Subject: [AccessD] TransferText working sporadically.
>
>
>Our Payroll guy has an Access .mdb which imports data from our Hours program
>(written in DataPoint), into Abra, our Payroll/HR package.  A few weeks ago,
>that database stopped working, and it is failing on a line of code that is
>DoCmd.TransferText.  It says it is unable to write to the database.
>
>It works from my machine (Windows 2000, running Access 97), but not the
>payroll guy's machine, (NT 4.0 workstation, access 97).
>
>Both have the same service packs, etc.
>
>Any thoughts?
>
>Drew
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list