Jim Lawrence (AccessD)
accessd at shaw.ca
Fri Apr 30 11:24:07 CDT 2004
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