Re: How to handle CD and DVD drived in VBA?

There is code at the Access web for determining the type of a drive.


--

Terry Kreft


"Lauren Wilson" <nospam@xxxxxxxxxx> wrote in message
news:lohqv19vpcse4e91t1pfltebghm2mdj1m7@xxxxxxxxxx

Hi folks,

As part of a built in backup utility in our A3K app, we allow the user
to specify a drive letter on which to make a backup of the back-end
database. Only one problem,

If the user specifies a drive letter that equals a CD or DVD drive,
Access naturally croaks with what appears to be a non-trappable error
when we attempt to create a folder on the specified drive:

If Not IsFolder(backPath) Then
MkDir backPath
End If

Anyone know of a better way to handle this problem?

Thanks for all responses.

-- LW


.

Relevant Pages

  • How to handle CD and DVD drived in VBA?
    ... As part of a built in backup utility in our A3K app, ... to specify a drive letter on which to make a backup of the back-end ... If the user specifies a drive letter that equals a CD or DVD drive, ...
    (comp.databases.ms-access)
  • Re: How to handle CD and DVD drived in VBA?
    ... As part of a built in backup utility in our A3K app, ... to specify a drive letter on which to make a backup of the back-end ... If the user specifies a drive letter that equals a CD or DVD drive, ... distinguish between different types of drives. ...
    (comp.databases.ms-access)
  • Re:How to handle CD and DVD drived in VBA?
    ... As part of a built in backup utility in our A3K app, ... to specify a drive letter on which to make a backup of the back-end ... If the user specifies a drive letter that equals a CD or DVD drive, ... distinguish between different types of drives. ...
    (comp.databases.ms-access)
  • Re: Re: How to handle CD and DVD drived in VBA?
    ... As part of a built in backup utility in our A3K app, ... to specify a drive letter on which to make a backup of the back-end ... If the user specifies a drive letter that equals a CD or DVD drive, ... distinguish between different types of drives. ...
    (comp.databases.ms-access)
  • How to copy locked or in-use files???
    ... I am trying to install a new HD and have loaded XP onto it and ... Is there anyway to specify to copy the entire directory and all its sub ... do I need to use some sort of backup utility or Norton Ghost.. ... And can this be done such that the backup data ...
    (microsoft.public.windowsxp.help_and_support)