Backup Back end - compile error

[PercyN]

Ref: thread705-999475

This thread seems to be exactly what I need to backup my back-end but when I compile the code I get a "User-defined type not defined" error on:
Dim fso As Scripting.FileSystemObject

Am I missing something?

Also if my back end is password protected, how can I tweek this code to work with that. I have see a few others but this looks by far the simplest.

 

[strongm]

Either change it to

Dim fso as Object

or, better, add a reference to the Microsoft Scripting Runtime library

 

[PercyN]

Perfect! Thank strongm.

Do you have any suggestions regarding using this for a password protected be?

 

[vbajock]

Don't put code in your back end database would be a start....

 

[PercyN]

Thanks vbajock, but there is no code in the back end. Its all in the from end. I'm trying to back up the back end from the front end.

 

[vbajock]

You better check again, because that's why you are getting that error.

 

[vbajock]

Oops, sorry, I misread your post....