Solved C&R Backend

[Kayleigh]

Looked at that and found this line:

DBEngine.CompactDatabase strDestination & ".cpk", strDestination, , , ";pwd=YourPassword"

However I currently have this:

 DBEngine.CompactDatabase sSourceFile, sSourcePath & sFileName & "_Temp" & sExt

Variables don't seem to match up?

 

[theDBguy]

Looked at that and found this line:

DBEngine.CompactDatabase strDestination & ".cpk", strDestination, , , ";pwd=YourPassword"

However I currently have this:

 DBEngine.CompactDatabase sSourceFile, sSourcePath & sFileName & "_Temp" & sExt

Variables don't seem to match up?

So, what happens if you changed yours to this?

 DBEngine.CompactDatabase sSourceFile, sSourcePath & sFileName & "_Temp" & sExt, , , ";pwd=YourPasswordHere"

Just curious...

 

[Kayleigh]

Works fantastic!!

 

[theDBguy]

Works fantastic!!

Excellent! Continued success with your project.