Missing Character

[Novice1]

I'm trying to open a front end database with VBS but I'm having trouble, which I believe is because of the SPACE in the path (Public Documents). See below. Other than renaming the file folder, is there a way I can open the application?


Dim accapp As Access.Application

Set accapp = New Access.Application

accapp.OpenCurrentDatabase
("C:\Users\Public Documents\SignInPlus\DEERS_Office\DEERSPlus.accdb")

Thank you

 

[CJ_London]

the space will not be an issue. Explain what you mean by 'having trouble' - you get an error, (if so what) nothing happens, wrong db opens, lights go out?

 

[Gasman]

This is how I would open the access db in my old job using vbs

HTH

Dim oAccess

'Open PPI caseflow

Set oAccess = CreateObject("Access.Application")
oAccess.Visible = True
oAccess.OpenCurrentDatabase("C:\Program Files\PPI Caseflow\PPI Caseflow.mde")