Language: ChineseGermanSpanishFrenchDutchItalianRussian
123 Flash Chat Forums

Go Back   TOPCMM Community > SWFKit > SWFKit Support

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-14-2008, 07:39 PM
Senior Member
 
Join Date: Feb 2003
Posts: 212
Default compact access database

I'm working with an access database and swfkit through ado.
But from time to time, the size of the mdb gets to high

In access i can do this to Compact and Repair a currently open database manually...
Go to Tools > Database Utilities > click Compact and Repair Database/Project.

Is there a way to do this also with swfkit and ado for users who haven't installed microsoft office
Reply With Quote
  #2 (permalink)  
Old 10-15-2008, 11:33 AM
Senior Member
 
Join Date: Dec 2002
Posts: 2,015
Default Re: compact access database

http://support.microsoft.com/?scid=k...30501&x=9&y=12
Code:
var jro = new ActiveXObject("jro.JetEngine");
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\nwind2.mdb;Jet OLEDB:Database Password=test", 
	"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\abbc2.mdb;Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test");
Reply With Quote
  #3 (permalink)  
Old 10-17-2008, 11:21 AM
Senior Member
 
Join Date: Feb 2003
Posts: 212
Default Re: compact access database

so simple: it works
thanks
Reply With Quote
Reply

Was this information helpful?    Yes No



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 05:23 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.