FiveTech Software tech support forums

Posted: **Thu Jul 18, 2013 8:41 am**

Hello,

Continuing with great and very usefull ADO functions created by Mr. Nages, it would be very interesting to have also the following:

- Optimice table.
- Backup table.

Thank you very much.

Posted: **Thu Jul 18, 2013 1:10 pm**

Lucas

- Optimice table.
- Backup table.

Both of your requests are have different answers depending on your Database. With MS Access you can 'compact and repair' as well as just copying the .mdb or .accDb using code .. however, Sql Server and Oracle are not that simple and require a Data Base Administrator to perform those tasks.

RIck Lipkin

Posted: **Thu Jul 18, 2013 2:10 pm**

Rick,

With MS Access you can 'compact and repair'

How to do it from ADO ? thanks

Posted: **Thu Jul 18, 2013 2:20 pm**

Antonio,

Antonio Linares wrote:Rick,

With MS Access you can 'compact and repair'
How to do it from ADO ? thanks

Code: Select all

oJro = CREATEOBJECT( "JRO.JetEngine" )

oJro:CompactDatabase( cConnectionString1, cConnectionString2 )

EMG

Posted: **Thu Jul 18, 2013 3:35 pm**

Enrico

From my notes I recall the parameters defined as ??

Code: Select all

cConnectionString1 := "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDatabase.mdb"
cConnectionString2 := "Provider=Microsoft.Jet.OLEDB.4.0;ataSource=MyCompactedDatabase.mdb"

Thanks
Rick Lipkin

Posted: **Thu Jul 18, 2013 3:39 pm**

Rick,

Rick Lipkin wrote:Enrico

cConnectionString1 is the path and name of the current .mdb ?
cConnectionString2 is the path and name of the new ( repaired ) .mdb ?

Thanks
Rick Lipkin

cConnectionString1 is the ConnectionString of the current .mdb
cConnectionString2 is the ConnectionString of the new ( repaired ) .mdb

EMG

Posted: **Thu Jul 18, 2013 3:43 pm**

Enrico

Thanks .. I went back and edited my post from my notes as you described it to me recently. I have not had a chance to try it yet

Rick Lipkin

Code: Select all

cConnectionString1 := "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDatabase.mdb"
cConnectionString2 := "Provider=Microsoft.Jet.OLEDB.4.0;ataSource=MyCompactedDatabase.mdb"

Posted: **Thu Jul 18, 2013 6:12 pm**

Hello,

Very exciting funcions.

MySQL has the command OPTIMIZE TABLE.

Oracle has it too.

Kind regards

FiveTech Software tech support forums

new ADO functions

new ADO functions

Re: new ADO functions

Re: new ADO functions

Re: new ADO functions

Re: new ADO functions

Re: new ADO functions

Re: new ADO functions

Re: new ADO functions