Ms Access makes database read-only and couldn't be updated with Java

Question

I have in my project a Ms Access database which worked fine before, now after formatting my computer I've run my project and It worked but when I opened the database with MsAccess 2007 and closed it. It won't get updated with the Java project.

I still have copies of database which wasn't opened with MsAccess and it works fine if I use it. so the problem is opening the database with MS Access - it kind of lock it read-only ( that's what the Jackcess says )

I didn't create DSN, I use jackcess directly with the directory of the .accdb file : String dbFileSpec = "src\\database.accdb"; — Gregor Samsa, May 27 '16 at 08:34

score 1 · Answer 1 · edited May 23 '17 at 11:58

1

I found the answer of one of the posts, It's the version of MsAccess It made the sort order French despite of General.

Here the answer by @Gord Thompson : "unsupported collating sort order" when trying to read from Access using Jackcess (Java)

edited May 23 '17 at 11:58

Community

1
1

answered May 27 '16 at 08:45

Gregor Samsa

115
12

Ms Access makes database read-only and couldn't be updated with Java

1 Answers1