David Emerson
davide at dalyn.co.nz
Tue Jun 1 16:28:49 CDT 2004
Has anyone else used Sagekey/Wise combination and know what is required (if anything) to register a file (and what it is) to allow importing of text? David At 2/06/2004, you wrote: >Thanks for the response. > >The client is logging in using their own username/password as set up in >SQL. I have checked the permissions on the table and they are ok. > >Is it possible that a dll needs to be registered to be able to import text? > >David > >At 31/05/2004, you wrote: >>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 >> >>-- >>_______________________________________________ >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Churton Park Wellington, New Zealand Ph/Fax (04) 478-7456 Mobile 027-280-9348