Help,
i am trying to compact and repair a workgrouped DB from within anohter DB, but i cant work out how to do it, if the DB is just passworded ( using the set DB password ) it works using:
but this wont work if its workgrouped because you obviously need to load the workgroup first.
and ideas?
thanks
i am trying to compact and repair a workgrouped DB from within anohter DB, but i cant work out how to do it, if the DB is just passworded ( using the set DB password ) it works using:
Code:
DBEngine.CompactDatabase DBLoc & DBName, DBLoc & "BKUK\" & DBName, , , DBPass
but this wont work if its workgrouped because you obviously need to load the workgroup first.
and ideas?
thanks