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