Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
The same command on a WIN-Me or WIN-2K Maschine does this:
Is the command for WIN-Me, WIN-2K, (WIN-NT4?) different?
I use the latest MS-Jet-Engine updates on all machines and winbatch + compiler 2003J
I think I may have tracked down the problem...
From Microsoft:
BUG: Database Compaction with SQLConfigDataSource Fails when Access Database is Password Protected http://support.microsoft.com/support/kb/articles/Q270/6/38.ASP
According to this link, I think you cannot use qConfigData to compact your database. See article for alternatives.
JRO does the job on WIN-XP, WIN-2K and WIN-ME:
SourceStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestOrg.mdb;Jet OLEDB:Database Password=test" DestStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestNew.mdb;Jet OLEDB:Database Password=test;Jet OLEDB:Engine Type=4" JE = ObjectOpen("JRO.JetEngine") JE.CompactDatabase(SourceStr, DestStr)Without The Parameter "OLEDB:Engine Type=4" the target-DB is converted to Type=5!.
Article ID: W15842
File Created: 2004:03:30:15:41:06
Last Updated: 2004:03:30:15:41:06