Programming Forums > Application Development > Visual Basic

melwinator · May 3rd, 2005, 5:12 AM

hi All,
I am converting code written in DAO into ADO.
one problem i face is that i am not finding an equivalent function / code for compressing an MS Access database using ADO 2.8. This can be easily done using DAO. Someone told me its possible using ADOX but HOW????
I've been trying to find a solution for this for days now!!!!!
Can anyone help me!!???

Rory · May 3rd, 2005, 1:56 PM

What do you mean by compressing: compacting/repair or physically zipping up the file?
Thanks.

melwinator · May 3rd, 2005, 11:43 PM

Yeah I mean compacting/repair. I want to do this cause i am making a utility to synchronize data in two Access databases. So once that is done, I want to compact the database.....

Rory · May 4th, 2005, 11:38 AM

I'm assuming you're using Jet in which case the way it actually works is reprocessing the whole database into a new one:

(Toggle Plain Text)

Set DBM = New JRO.JetEngine
With DBM
.CompactDatabase ConnectionString1, ConnectionString2
End With
Set DBM = Nothing

Where ConnectionString1 and ConnectionString2 are normal formatted ADO connection strings, including username/password for both.
Note that you'll need exclusive access, including to the security tables.
Hope this helps.

May 3rd, 2005, 5:12 AM	#1
melwinator Newbie Join Date: Mar 2005 Posts: 11 Rep Power: 0	Compressing an Access database using ADO hi All, I am converting code written in DAO into ADO. one problem i face is that i am not finding an equivalent function / code for compressing an MS Access database using ADO 2.8. This can be easily done using DAO. Someone told me its possible using ADOX but HOW???? I've been trying to find a solution for this for days now!!!!! Can anyone help me!!???

May 4th, 2005, 11:38 AM	#4
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	I'm assuming you're using Jet in which case the way it actually works is reprocessing the whole database into a new one: (Toggle Plain Text) Set DBM = New JRO.JetEngine With DBM .CompactDatabase ConnectionString1, ConnectionString2 End With Set DBM = Nothing Set DBM = New JRO.JetEngine With DBM .CompactDatabase ConnectionString1, ConnectionString2 End With Set DBM = Nothing Where ConnectionString1 and ConnectionString2 are normal formatted ADO connection strings, including username/password for both. Note that you'll need exclusive access, including to the security tables. Hope this helps.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2005, 1:56 PM	#2
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	What do you mean by compressing: compacting/repair or physically zipping up the file? Thanks.

May 3rd, 2005, 11:43 PM	#3
melwinator Newbie Join Date: Mar 2005 Posts: 11 Rep Power: 0	Yeah I mean compacting/repair. I want to do this cause i am making a utility to synchronize data in two Access databases. So once that is done, I want to compact the database.....

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Visual Basic

Compressing an Access database using ADO