How to delete an access database .mdb file using VBA code? 2

[VBUser77]

How could I delete an access database .mdb file using VBA code?

Seemingly Docmd.DeleteObject doesn't work for access database file

Thanks

Jay

 

[SiJP]

Well, as long as it is not the current database you are in...

Dim fso as Object
Set fso = CreateObject("Scripting.FileSystemObject")
fso.DeleteFile myfilelocation
Set fso = nothing




------------------------
Hit any User to continue

 

[PWise]

or try this
kill "pathandfilename

 

[VBUser77]

Thanks. Do you know how to rename an access file in VBA.

 

[PWise]

to copy file
FileCopy source, destination

to rename
Name oldpathname As newpathname

 

[VBUser77]

The rename thing works so fine. Thanks a lot.

Is there a way in VBA to create .mde file from an existing .mdb file.

Thanks

Jay

 

[PWise]

this will create a new .mdb
Dim a As Access.Application
Set a = CreateObject("Access.Application.9")
a.NewCurrentDatabase "c:\a.mdb"
a.Quit

this will create a new .adp
Application.CreateAccessProject "c:\a.adp