var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Open Accessdatabase from another Accessdatabase
I want to open Accessdatabase from another Accessdatabase without opening any objects (just open the database, visible for the user) in code. Does anyone know the syntax?
Shell "msaccess.exe " & Chr(34) & "C:\Path\File.mdb" & Chr(34)
Space in the path?
It will work if there aren't any spaces in the path. Do you know how to do if there are spaces?
Actually it should work with spaces, because of the Chr(34) characters (").
I have tested something like:
strPath = "C:\My Documents\My Access Databases\TestDb.mdb"
Shell "msaccess.exe " & Chr(34) & strPath & Chr(34)
and it worked OK.
Shell "msaccess.exe " & """" & strPath & """"
which I use in my apps.
Thankyou it worked fine now