How to Check if a Drive is Available - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

How to Check if a Drive is Available

Garry Frank

15 months ago

I am trying to create a button that backs up all my databases with one click. I have three databases I need to back up on a regular basis, and I would like to back them up with one button. I normally back my files up on a flash drive (E:) but sometimes forget to insert the drive. If I press the button without the drive inserted, it doesn't back up the file and doesn't inform me of my mistake. How do I check to see if the drive is inserted, and send a message that tells me the backup didn't work because of the error?

Note: I think backing up to the C: drive is stupid, because if the hard drive crashes, you lose the original AND the backup.

	Kevin Robertson @Reply 15 months ago
Give this a go (see screenshot) and let me know if it works for you.

	Kevin Robertson @Reply 15 months ago

	Alex Hedley @Reply 15 months ago
`DriveExists` https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/driveexists-method Details `Set fso = CreateObject("Scripting.FileSystemObject") Debug.Print fso.DriveExists("C") 'Result: True Debug.Print fso.DriveExists("E") 'Result: False` https://analystcave.com/vba-filesystemobject-fso-in-excel/vba-driveexists/

	Garry Frank OP @Reply 15 months ago
Okay, I couldn't get Kevin's method to work (I was still looking for a typo), when I figured out that all I needed was a reminder MsgBox asking me if I had put the flash drive in. It works. I do appreciate your response though and will go ahead and test both of these. Thanks for your input.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View