SamirNaenenjad
Programmer
I am using a JET replication object to compact/repair an Access DB, then I ftp the DB to a server. I am using the following code to do the repair:
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sirematchd\smbackup.mdb", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sirematchd\SMBackupC.mdb;Jet OLEDB:Engine Type=4"
The problem is, at the very end of the ftp, I get an invalid parameter error from wininet. Yet, if I repair the DB using Type=5 (JET 4.0), the same code works just fine. Does anyone know why using JET 3.5 causes the ftp to break but using JET 4.0 doesn't?
Thanks for any insight,
A.J.
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sirematchd\smbackup.mdb", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sirematchd\SMBackupC.mdb;Jet OLEDB:Engine Type=4"
The problem is, at the very end of the ftp, I get an invalid parameter error from wininet. Yet, if I repair the DB using Type=5 (JET 4.0), the same code works just fine. Does anyone know why using JET 3.5 causes the ftp to break but using JET 4.0 doesn't?
Thanks for any insight,
A.J.