After I run code to compact an Access database from VB I am left with two databases. How do I delete the original database and rename the compacted database?
Thanks.
Kill pathname permanntly removes a file object. Note that Wild card characters are permitted as part of the pathname variable. Also, pathname is a string or a string variable.
Name Oldname as NewName Changes the name of the file and (optionally) move it to a new location.
e.g.
OldName = "C:\MYDIR\OLDFILE"
NewName = "C:\YOURDIR\NEWFILE"
Name OldName As NewName ' Move and rename file.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.