Marco Amadei

The boolean returned has a completely different meaning, it's true if it is a ResultSet, false if it isn't, see jdbc javadoc

It's likely a encrypted database, isn't it? If so, see how to use the jackcessOpener parameter on the ucanaccess web site. Il Mer 21 Set 2022, 22:22 amwfc amwfc@users.sourceforge.net ha scritto: We are kind of dead in the water, due to the above error. Any tips on resolving it? What does this error mean, and how can I fix it? https://sourceforge.net/p/ucanaccess/discussion/help/thread/26a88b070b/?limit=25#7741 Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/help/...

Thank you Fred, I didn't treat PERIOD as keyword, next version will fix it for better compatibility.

If you try to use the console.bat (in the distribution) to open the file what do you see? Could you send the console output? Il giorno lun 25 ott 2021 alle ore 13:56 Lon Parisi lonparisi@users.sourceforge.net ha scritto: Hello, I have written to this forum before but have not been able to resolve the connection time being SO long. My MS Access database is currently about 54M. It takes well over 4 minutes to create a connection. There is a slow amount of growth to this database and the connection...

It is not our game, but you should setAutocommit(false) at the start, and then commit just each 1000-2000 records... performance will improve dramatically... or much better, do it all directly with jackcess. Il Gio 23 Set 2021, 20:09 Steven Rubin strubin9@users.sourceforge.net ha scritto: I am trying to build a large table (105 columns and over a million rows). Using Access, I can use Import / External Data and then give it a big text file (tab separated). It takes barely any time at all. Now I want...

Ok. It will be fixed in the 6.0.0 Il Ven 10 Set 2021, 14:08 Sproketboy sproketboy@users.sourceforge.net ha scritto: Hi I'm using 5.0.1 with hsqldb 2.5.1 Column name incorrect after create table. https://sourceforge.net/p/ucanaccess/discussion/general/thread/52ae8bb570/?limit=25#72b7/2875/cb65 Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to https://sourceforge.net/p/ucanaccess/discussion/general/ To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/ucanaccess/admin/discussion/forums....

Which version are you using? Il Ven 10 Set 2021, 11:49 Sproketboy sproketboy@users.sourceforge.net ha scritto: CREATE TABLE Customers ( [Customer ID] varchar(10) PRIMARY KEY NOT NULL, [Company Name] VARCHAR(30) NULL, [Contact Name] VARCHAR(30) NULL, [Contact Title] VARCHAR(10) NULL, [Address] VARCHAR(40) NULL, [City] VARCHAR(30) NULL, [Region] VARCHAR(10) NULL, [Postal Code] VARCHAR(10) NULL, [Country] VARCHAR(2) DEFAULT 'US', [Phone] VARCHAR(30) NULL, [Fax] VARCHAR(30) NULL, [Status] CHAR(1) NULL,...

No, they were unknown errors, but I'll verify the bugs ASAP and let you know here when the fixes will be released.