[ODBC] How to compact a base ?

[yves piel]

Hello,
I'm developping a java application which use an ms-access database via
jdbc/odbc bridge.
However, it seems that ms-access databases have to regularly been
compacted (for indexes and page size).
So how can I do it from java since I haven't got Access nor vb ?

thank you :)

[MGFoster]

yves piel wrote:

Hello,
I'm developping a java application which use an ms-access database via
jdbc/odbc bridge.
However, it seems that ms-access databases have to regularly been
compacted (for indexes and page size).
So how can I do it from java since I haven't got Access nor vb ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The Access DBEngine has to be running or you wouldn't be able to access
the data. That said, using Automation, you can use this command:

DBEngine.CompactDatabase olddb, newdb, locale, options, password

From the Access Help file:

/begin quote/

olddb - A String that identifies an existing, closed database. It can be
a full path and file name, such as "C:\db1.mdb". If the file name has an
extension, you must specify it. If your network supports it, you can
also specify a network path, such as "\\server1\share1\dir1\db1.mdb".

newdb - A String that is the file name (and path) of the compacted
database that you're creating. You can also specify a network path. You
can't use the newdb argument to specify the same database file as olddb.
/ end quote /

Locale, options and password parameters are optional. Leave them alone
if you just want the same type, version, etc. as the oldDB. If the DB
is password protected set the password parameter to ";pwd=ThePassword".
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQxNMCYechKqOuFEgEQLBVQCgqhRZ3AC4uMSLOY9G0ZmMOS V4gTwAoPWZ
sLqPxRtMVwgnFPyHABQCPtzm
=5G95
-----END PGP SIGNATURE-----

[yves piel]

thank you :)

MGFoster wrote:

yves piel wrote:

Hello,
I'm developping a java application which use an ms-access database via
jdbc/odbc bridge.
However, it seems that ms-access databases have to regularly been
compacted (for indexes and page size).
So how can I do it from java since I haven't got Access nor vb ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The Access DBEngine has to be running or you wouldn't be able to access
the data. That said, using Automation, you can use this command:

DBEngine.CompactDatabase olddb, newdb, locale, options, password

From the Access Help file:

/begin quote/

olddb - A String that identifies an existing, closed database. It can be
a full path and file name, such as "C:\db1.mdb". If the file name has an
extension, you must specify it. If your network supports it, you can
also specify a network path, such as "\\server1\share1\dir1\db1.mdb".

newdb - A String that is the file name (and path) of the compacted
database that you're creating. You can also specify a network path. You
can't use the newdb argument to specify the same database file as olddb.
/ end quote /

Locale, options and password parameters are optional. Leave them alone
if you just want the same type, version, etc. as the oldDB. If the DB
is password protected set the password parameter to ";pwd=ThePassword".

But what is the DBEngine ? THe application use a
jdbc(java)/odbc(windows). So How can I access DBEngine from odbc ?

thanks :)

[Douglas J. Steele]

You might be able to use JRO (Jet Replication Objects)

See whether the VC++ example in http://support.microsoft.com/?id=230501
helps.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"yves piel" <yv************@free.fr> wrote in message
news:43***********************@news.free.fr...

Hello,
I'm developping a java application which use an ms-access database via
jdbc/odbc bridge.
However, it seems that ms-access databases have to regularly been
compacted (for indexes and page size).
So how can I do it from java since I haven't got Access nor vb ?

thank you :)