Thanks very much for that, works just how I need.
Not real sure what part of some similar trial code I used that makes it different:
Code:
Dim oAccess As Access.Application
Set oAccess = CreateObject("Access.Application")
With oAccess
.OpenCurrentDatabase strTmp 'strTmp = the specified db
.visible = True
.UserControl = True
End With
Application.Quit
The only difference I can see was using CreateObject, or .visible (Not needed) or maybe .UserControl. Either way I'm happy...
To try and save you wondering, db1 is the front end of our database. db2 is only for updating - it doesn't touch any data tables in db1. db2 grabs db1 exclusively only to know it has fully closed, then grab a couple of properties (Like where the back end is). It then unzips a new db1 update file, does a few checks, renames old db1 as a backup to allow restore, replaces db1 with the update, sets the back end etc..., then restarts db1. db2 function in life has now ended and gets deleted by db1.
I can't do this from db1.
Thanks again.
swas