TechRepublic member william.beissel frequently uses a snippet of code to open .adp projects in MS2007, but it won't open a .accdb file. Please post your explanation and/or solution in the discussion thread.
TechRepublic member william.beissel submitted the following question.
I am trying to open a .accdb database using the following commands:
myshell = "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" & " " & myFile
myAppID = Shell(myshell, 3)
myFile is a valid path and .accdb file name.
When I execute the commands, I get the following error: "The command line
you used to start Microsoft Access contains an option that Access does not recognize..."
I use this same code to open .adp projects in MS2007 all day long. Why won't it open a .accdb file too? Thanks for any help you can provide.
Please post your explanation and/or solution in the discussion thread. If you can successfully help this member, we will send you a TechRepublic coffee mug.