You can still use a bat file, though they tend to be called .cmd files these days.
You can also use VBS scropt which is a little like VBA
Then you can buy an installer program with lots of bells and whistles.
I just used a VBS script when I was using Access in work.
Here is one I found, though I am not sure if I ever used it, as I used Bob Larsen's code, but it should give you an idea?
Code:
Option Explicit
Dim strLocal, strRemote,strDBPath
Dim oAccess
Dim objFSO, objLocal, objRemote
strlocal = "C:\DB\Employee.accde"
strremote = "S:\DB\Employee.accde"
strDBPath = LEFT(strLocal,InstrRev(strLocal,"\"))
SET objFSO = CREATEOBJECT("Scripting.FileSystemObject")
SET objLocal = objFSO.GetFile(strlocal)
set objRemote = objFSO.GetFile(strremote)
if objRemote.DateLastModified > objLocal.DateLastModified Then
'objFSO.DeleteFile strLocal
objFSO.CopyFile strRemote,strDBPath,True
wscript.echo "Latest version installed"
end if
Set oAccess = CreateObject("Access.Application")
oAccess.Visible = True
oAccess.UserControl = true
oAccess.OpenCurrentDatabase("C:\DB\Employee.accde")
Set objFSO = Nothing
Set objLOcal = Nothing
Set objRemote = Nothing
Set oAccess = Nothing