Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compacting Access DB

Status
Not open for further replies.

SamirNaenenjad

Programmer
Mar 20, 2002
13
0
0
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top