Hi,

Can anyone tell me why this piece of code shuts access down once the procedure has ended, and also how to stop it doing it?

Code:
Dim DPath As String
DPath = "S:\Hockney Folder Structure\CUSTOMER SERVICE\Michael\ACBS\ACBS.mdb"
Set oApp = CreateObject("Access.Application")
oApp.Visible = True
oApp.OpenCurrentDatabase DPath
Thanks

C19