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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup Back end - compile error

Status
Not open for further replies.

PercyN

Programmer
May 16, 2007
86
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.
 
Either change it to

Dim fso as Object

or, better, add a reference to the Microsoft Scripting Runtime library
 
Perfect! Thank strongm.

Do you have any suggestions regarding using this for a password protected be?
 
Don't put code in your back end database would be a start....
 
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.
 
You better check again, because that's why you are getting that error.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top