Re: Name function in Access 2002 (XP)
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 09/09/04
- Next message: Marshall Barton: "Re: Command line help"
- Previous message: Brendan Reynolds: "Re: After Update"
- In reply to: pvp: "Name function in Access 2002 (XP)"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Name function in Access 2002 (XP)"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Name function in Access 2002 (XP)"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 22:53:01 +0800
There are *myriads* of reasons that a rename can fail, e.g.:
- the old file name does not exist;
- the path is invalid;
- the network connection is not available;
- the drive is empty;
- the disk is corrupted (chkdsk error);
- the new file name is invalid (bad characters, too long, ...);
- the new name includes a path that does not yet exist);
- the media is not writable (CD-ROM);
- the disk is write protected;
- you do not have write permission to the drive/file/folder;
- the file is currently in use;
- your software is being run on a future file system, and an error occured
that you never imagined;
- many others.
The VBA errors are very specific when there is a problem. The only sensible
approach is to use error handling, and let VBA report what particular error
occurred if there was a problem.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "pvp" <anonymous@discussions.microsoft.com> wrote in message news:083101c4965b$8b380070$a401280a@phx.gbl... > Guys, I am doing a complicated series of renames of files > from Access VBA. I need to know how such a (re)name > operation can fail so that I know whether to try and > catch such failures. Has it ever failed to anyone's > knowledge? > > Many thanks.
- Next message: Marshall Barton: "Re: Command line help"
- Previous message: Brendan Reynolds: "Re: After Update"
- In reply to: pvp: "Name function in Access 2002 (XP)"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Name function in Access 2002 (XP)"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Name function in Access 2002 (XP)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
