Jim Lawrence (AccessD)
accessd at shaw.ca
Tue Jun 1 00:53:25 CDT 2004
David: How do you log on to you local server? (username/password/servername/databasename) You may not have logged in to your client's server properly or have access rights. If they are using pass-through or server validation make sure your username and password has been added to the security list or attached user group and your security is high enough. Finally, make sure, as a user, you actually have write rights to the tables and executable rights to any SPs. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson Sent: Monday, May 31, 2004 10:26 PM To: accessd at databaseadvisors.com Subject: [AccessD] Importing Text File Access XP ade, SQL2000 I am transferring a text file into an SQL BE for processing. The command I am using is - DoCmd.TransferText acImportDelim, , "dbo.ttmpTOURawData", strFullName, False It works fine on my development machine. When I take it to my client's site and run the code from a run time installation (using Sagekey/Wise installation) I get an error message Error 31519 - You cannot import this file. The destination table exists on the client's server. I cannot find anything on the web or help or BOL. Is there a file that should be included in the installation to allow importing? I can export text files from within the program ok. Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Churton Park Wellington, New Zealand Ph/Fax (04) 478-7456 Mobile 027-280-9348 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com