new ADO functions

[lucasdebeltran]

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.

[Rick Lipkin]

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

[Antonio Linares]

Rick,

With MS Access you can 'compact and repair'

How to do it from ADO ? thanks

[Enrico Maria Giordano]

Antonio,

Rick,

With MS Access you can 'compact and repair'

How to do it from ADO ? thanks

Code: Select all  Expand view  RUN

oJro = CREATEOBJECT( "JRO.JetEngine" )

oJro:CompactDatabase( cConnectionString1, cConnectionString2 )

EMG

[Rick Lipkin]

Enrico

From my notes I recall the parameters defined as ??

Code: Select all  Expand view  RUN

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

Thanks
Rick Lipkin

[Enrico Maria Giordano]

Rick,

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

[Rick Lipkin]

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  Expand view  RUN

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

[elvira]

Hello,

Very exciting funcions.

MySQL has the command OPTIMIZE TABLE.

Oracle has it too.

Kind regards