Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
    Bookmark Topic Watch Topic
  • New Topic

Compact and Repair Access Database

 
Hydra Iris
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

I have this java project that uses a very large Access database. Recently I discover that I need to performed "Compact and Repair Database" frequently. (I have no intention to use a SQL server)

I like to check whether is there any way, I could run/activate the "compact and repair" utilities using java coding.

Thanks
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Report post to moderator
Do you need to run that utility to "compact" or to "repair"? Either would scare me - make sure you're backing up the DB frequently. It may be a sign that the DB is outgrowing the limits of Access (which wasn't meant to hold large amounts of data).

I don't think there's a direct way, but you may be able to use JNI and/or a COM bridge (like Jacob) to access Access internals or utilities, and call the respective methods.
 
Mr. C Lamont Gilbert
Ranch Hand
Posts: 1170
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Report post to moderator
I dont think access has problems holding large amounts of data. It has problems with large amounts of access...

Anyway, check here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_25.asp
[ August 08, 2006: Message edited by: Mr. C Lamont Gilbert ]
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Report post to moderator


Message will appear after click on this link

"We apologize for the inconvenience, but the web site address you have requested (http://msdn.microsoft.com/library/en-us/odbc/htm/odbcjetsdk_25.asp) cannot be found."

and redirected to http://msdn.microsoft.com/404/default.aspx

thanks,
 
Hydra Iris
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Report post to moderator
Noted.....Thanks.
 
    Bookmark Topic Watch Topic
  • New Topic