Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compact an ACCESS db (.mdb) programmatically
Message
 
To
14/11/2001 07:27:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00581402
Message ID:
00581436
Views:
18
Hi,
You can make it using JRO (Jet and Replication Objects):
strConnOriginal = "Provider=Microsoft.Jet.OLEDB.4.0;" + ;
                  "Data Source=E:\Orig.MDB;"
strConnNew = "Provider=Microsoft.Jet.OLEDB.4.0;" + ;
             "Data Source=E:\New.MDB;"
jroEngine = CreateObject("JRO.JetEngine")
jroEngine.CompactDatabase(strConnOriginal, strConnNew)
>How can I compact an ACCESS db (.mdb) programmatically using SQLConfigDataSource or by using the OLE technology ?
Previous
Reply
Map
View

Click here to load this message in the networking platform