Error From External Database Driver 11270
Contents |
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Unexpected Error From External Database Driver (8961)
of this site About Us Learn more about Stack Overflow the company
Unexpected Error From External Database Driver (1309)
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges unexpected error from external database driver excel Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: https://groups.google.com/d/topic/microsoft.public.vb.database.odbc/kILAVf-1bnw Sign up getting an Unexpected error from external database driver (1) when importing data from excel to access up vote 4 down vote favorite I have a 2010 Excel file with a sheet that spans 34864 rows and 1387 columns. I'm trying to import it into Access 2010 with the import wizard, but when I select that sheet, Access goes unresponsive, and http://stackoverflow.com/questions/10421914/getting-an-unexpected-error-from-external-database-driver-1-when-importing-dat after several seconds gives me a "Unexpected error from external database driver (1)" Is this due to the size of the sheet or is there something in the cells that stops it from working. Other sheets from the same file import with no problem. excel ms-access import share|improve this question edited Jun 1 '15 at 3:57 Dyrandz Famador 3,14851027 asked May 2 '12 at 21:20 user1251858 731310 1 Suggest you try a test at 1/2 size import, and then move up if that's successful. –octopusgrabbus May 2 '12 at 21:22 add a comment| 6 Answers 6 active oldest votes up vote 3 down vote Check out this for Access 2010 specification: http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx. In your case, it might be number of columns, so try to import less than 255 first. Also, it might be the size of the data in the columns or data types (importing text into numeric etc.) share|improve this answer answered May 2 '12 at 21:44 Igor Turman 1,83511321 it's down to 72 columns now, and I removed the majority of elements so there are only 1863 rows
External Database Driver If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.dbforums.com/showthread.php?984554-error-to-dbase-connect-Unexpected-Error-From-External-Database-Driver click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: error to http://sagecity.na.sage.com/support_communities/sage_timeslips/f/51/p/657/1886 dbase connect : Unexpected Error From External Database Driver Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to error from Threaded Mode 02-21-04,19:14 #1 ugurbaytun View Profile View Forum Posts Registered User Join Date Feb 2004 Posts 1 Unanswered: error to dbase connect : Unexpected Error From External Database Driver I was trying to import a DBASE IV with DAO in VB, but I'm getting this error message to some computers: Unexpected Error From External Database Driver . Please help! Thanks. Reply With Quote 04-05-04,11:38 #2 error from external sswan View Profile View Forum Posts Registered User Join Date Apr 2004 Posts 8 I gather from your post that this isn't a problem that is occurring on all machines you are running the app on, correct? If that's the case, then here are a few things you can check. Are you using ODBC for the import process? If so make sure you have the ODBC settings across machines set properly. If you aren't using ODBC, then you should check the version of the driver you are specifying in your DAO connect string. There may be a version compatibility issue between your machines. If the app is running in a networked environment then this may be a security rights issue. Make sure that the user has proper access rights to the directory containing your database. Reply With Quote 05-02-06,04:15 #3 piero_di_cavezzo View Profile View Forum Posts Registered User Join Date May 2006 Posts 1 error connecting Paradox tables from Access I had same problem as you refer to the solution was: Open the Borland Database Administrator (BDE) and have a look to: Configuration Drivers Native Paradox NET DIR The users MUST have access in C
Construction and real estate Wholesale Distribution Manufacturing Product quick access: Sage One Sage 50 Accounting Sage 100 ERP Sage 300 ERP Sage ERP X3 Sage HRMS Sage Impact Sage Life Sage Payments Sage Payroll SageCity Site Search Sage City User Site Search Sage City User SageCity Home Support Business Partners Accountants Students Town Hall Blogs More ... Sage Timeslips Sage Timeslips Forum Home Forums Blog Training Ideation ACA Members More Cancel This group requires membership for participation - click to join Paradox lock error code returned when accessing data using ODBC Hi,I have created an ODBC connection to my TimeSlips database (using the Microsoft Paradox driver)andI have written a .Net aplication that uses this DSN toinsert data into the Referenc table.My application inserts records successfully, however if I am concurrently running TimeSlips, my application fails with error code:[Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (11270).Research on Google has suggested this is due to lock files created in the TimeSlips data folder. Indeed, when TimeSlips is launched, the two files PDOXUSRS.LCK and PARADOX.LCK are created in the data folder, and while these exist, I cannot use my ODBC connection to write to the table.Is there any way I can write to the TimeSlips database while someone is running TimeSlips? I.e. Can I write to the table while these LOCK files are there?Thank You NicholasD1980 8 Dec 2010 7:02 PM Cancel 1 Reply Caren2 9 Dec 2010 9:15 AM In reply to Nancy Duhon: What you are trying to do is unsupported and to me is dangerous.. The lock files are there for a reason - they are created to prevent two people writing to the same record at the same time.I'd be worried about data corruption.I don't know about other people but the only way I support writing to the database is through proper use of a license which probably requires use of the SDK.. Cancel 866-996-7243 (SAGE) google facebook youtube linkedin twitter instagram sage city © 2016 The Sage Group plc, its licensors or its affiliated companies. Sage, Sage logos, and Sage product and service names mentioned herein are the trademarks of The Sage Group plc, its licensors, or its affiliated companies. All other trademarks are the property of their respective owners. For more information, visit www.sage.com. Sage Products Sage One Sage 50 Accounting Sage 100 Sage 300 Sage X3 Payroll Payments View all products Support Product Support Training Sage University Find an accounting or financial exper