Slow initial connection and data missing MS Access
A pure Java JDBC driver for Microsoft Access database files
Brought to you by:
jamadei
Menu
▾
▴
Hello,
I'm using UCanAccess with Java to update an MS Access database. My database size is not all that large (34m) and I am the only user of the database so there is no shared connectivity issues. I need the ability to write to this database.
2 Issues I am Experiencing
First - I have noticed that the inital connection time takes around 30 seconds. That seems extremely long to me since connecting via any Windows MS product is almost instantaneous. I understand that there is a sort on in-memory copy of the database that needs to be made, but I can't imagine this is a normal connection time.
Second - when I update MS Access, the results are never seen until I Compact and Repair the database. There must be some technological reason this is happening and I'm sure there is a fix but I've searched and I cannot find anyone else having this issue.
Any help with improving the connectivity time and the reasons the database doesn't see the updates before a Compact and Repair
Intial connection time is something like a dbms start-up time and it depends on the data size and other factors. Because an access db is thought as desktop db, the mean load time (first connection) is within the second.
You don't need to use Compact and Repair, you just need to close and reopen your access db Access application don't recognize changes in data, even if changed data are already persisted .
Last edit: Marco Amadei 2020-03-04
When you say the "mean load time (first connection) is within the second" does this mean it should only take a second to connect? Because it surely is not doing that. It lliterally takes like 30 seconds and the DB is currently 34M.
"You don't need to use Compact and Repair, you just need to close and reopen your access db Access application don't recognize changes in data, even if changed data are already persisted ."
So is the data actually there is a good state but MS Access just isn't displaying it?
Even less for a 34M db. Unless in this db there are one or more external linked tables to other large db or something unexpected in the db structure. If not, there is some UCanAccess independent problem in your enviroment or database
Yes.
Last edit: Marco Amadei 2020-03-04
So you are correct. If I open and close the database, the data is indeed there! Good to know. Now, on to the next issue. You said: " Unless in this db there are one or more external linked tables to other large db or something unexpected in the db structure. If not, there is some UCanAccess independent problem in your enviroment or database". I do not have any external links. All the data is completely contained in the MS Access database. Can you elaborate on this UCanAccess independent problem in my environment and how to diagnose it please?