Can access grab a file and move it to another Drive???

[Z1nkstar]

Okay I have an access database that is shared with 15+ people it is split oriented it has a front side (Which is the file I want to move) and that is located on a drive on a server then there is the backend (Which is located on the same drive) the users only get a copy of the front end so I was wondering If I could make a button that will copy that file from drive X:\DLDB\DLDB.accdb and send it to there documents or even the desktop would be considerable . . . Then close out Access so that they can open the Updated Version???

[pbaldy]

Check out FileCopy in VBA help.

[Z1nkstar]

Private Sub Command0_Click()
Dim STA As String
Dim GDE As String


STA = "X:\DLDB\DLDB.accdb"
GDE = "C:\Users\michael\Desktop"


FileCopy STA, GDE


End Sub

I Done it like this but also like this and neither work

FileCopy "X:\DLDB\DLDB.accdb", "C:\Users\michael\Desktop"


FileCopy STA, GDE

Am I doing Something wrong well also with the first one I get permission denied is there anything I can do about that?