How to start msaccess 2010 in runtime

[andre_lag]

Hello all,

I try to start msaccess in runtime mode, but an .accdr will not start.

this is the code try to use, without /runtime in the code the .mdb and .accdb works great

(startapp "C:\\Program Files (x86)\\Microsoft Office\\Office14\\MSACCESS.EXE" /runtime path)

Anyone a idea?

thanks in advance

André

[Hallex]

Try something like this:

(if (findfile (setq msfile "C:\\Program Files\\Microsoft Office 15\\root\\office15\\MSACCESS.EXE"))
(startapp "C:\\Program Files\\Microsoft Office 15\\root\\office15\\MSACCESS.EXE" (strcat (getvar "dwgprefix") "NewDBTest.accdb"))
(alert "Check for existing MSACCESS.EXE file on your PC"))

 Change expression to your settings

[andre_lag]

Hello Hallex,

Thanks for your reply.

It works great so far, but if i change the extention from accdb to accdr it won't launch anymore.

Use the runtime modus to hide the navigation pane and menu's so that nobody can change tables, forms, etc. 

Read somthing on the web about to use a switch in the command-line?

Think that is not applicable for lisp.

How can i launch a runtime db with lisp?

André

[Hallex]

Sorry, André
I could not resolve this issue on my end 😞

[hgasty1001]

Hi,

I'm not sure, but if you put the access start command and switches in a batch file, you can use 

(acet-sys-command "the .bat file")

Gaston Nunez

[hmsilva]

André,

I couldn't test, but from the Access help, first the path followed by the parameters...

It may be something like

(startapp "C:\\Program Files (x86)\\Microsoft Office\\Office14\\MSACCESS.EXE"  path /runtime)

Henrique

[andre_lag]

Thanks Henrique,

I have try this, but doesn't work.

the only answer on the command-line is nil.

André

[hmsilva]

---

andre_lag wrote:

 ...

I try to start msaccess in runtime mode, but an .accdr will not start.

this is the code try to use, without /runtime in the code the .mdb and .accdb works great

(startapp "C:\\Program Files (x86)\\Microsoft Office\\Office14\\MSACCESS.EXE" /runtime path)

...

---

Andre,

one last attempt, again without being able to test (I don't have acess in this pc), and again from the help,

"if you double click on the .accdr file and Access will load in Runtime mode."

So, if you use

(startapp "C:\\Program Files (x86)\\Microsoft Office\\Office14\\MSACCESS.EXE" "c:\\MyPath\\MyDatabase.accdr")

without the runtime switch, should load in Runtime mode...

Henrique

[andre_lag]

Henrique,

Thanks again.

Access launched but give an error message and said that

i must use the switch /runtime in the command-line.

i give up and try somthing else like use accdb and than hide the navigation pane

and the menu's.

Thanks,

André

[hmsilva]

Sorry André,
I was not much help...

Henrique

[andre_lag]

Hi Gasty,
Made a batch file and it works as you said,
and guess what? it works only wthout switches.
Thanks
Andre

[hgasty1001]

Hi,

It's working here, this is the only line in the batch:

"C:/Program Files/Microsoft Office/Office14/msaccess.exe" "C:/Dev/Access/FrmSampl.accdr" /runtime

I call the batch using the acet-sys-command : (acet-sys-command "C:/Dev/Access/access.bat")

Hope this help.

Gaston Nunez

[andre_lag]

Hi Gaston,

Thanks, works great.

I use the database with ac electrical in several projects, get with API the active project

and want that written in the batch file.

Is it possible that autolisp make a batch file in the active projectfolder?

Like:

"C:/Program Files/Microsoft Office/Office14/msaccess.exe" "C:/Dev/ACT_PRJ.accdr" /runtime

ACT_PRJ is then the actual project folder.

Thanks

André

[hmsilva]

André just a thought,

if you double click on the .accdr file and Access will load in Runtime mode,

did you try to load in Runtime mode using a shell, perhaps something like this

(command "sh" (strcat "\"C:/Dev/ACT_PRJ.accdr\""))

Henrique

[hgasty1001]

Hi,

This little lisp should write the batch for you:

(defun CreateAccessBatch(AccessExePath dbPath accdrFileName / fp StrLine BatchFileName)
  (setq BatchFileName (strcat dbpath accdrFileName ".bat"))
  (setq fp (open BatchFileName "w"))
  (if fp
    (progn
      (setq StrLine (strcat (chr 34) accessExePath (chr 34) " " (chr 34) dbpath ".accdr" (chr 34) "/runtime")) 
      (write-line StrLine fp)
      (close fp)
    )
  )
)

 I think the arguments are self explanatory, but the call in this case should be:

(CreateAccessBatch "C:/Program Files/Microsoft Office/Office14/msaccess.exe" "C:/dev/" "ACT_PRJ")

Glad to help.

Gaston Nunez

[andre_lag]

Hi Gaston,

Thanks for your reply, it works great until to launch bat file, will attach the file

acet-sys-command won't work, try with the full path as well as you can see.

An doubleclick on the bat file works

can you help?

[andre_lag]

Sorry guys, it take some time.

I solved this problem, stupid i am so easely

with (startapp....)

thanks to all for the help

regards

André

[hmsilva]

---

@andre_lag wrote:

Sorry guys, it take some time.

I solved this problem, stupid i am so easely

with (startapp....)

...

---

André,

if possible, share with us the solution ,it  can be helpful to others in the same situation...

Henrique

[andre_lag]

Hi, everyone

Of course, sorry, I will be more careful next time to share the solution(s)

Use (startapp BatchFileName) instead of (acet-sys-command BatchfileName)

acet-sys-command did'nt work in my case.

Changed some variable names and use API from ace, but i think the attached code is clear.

At the end need to close the cmd-window, because it stay's open during the access session.

Regards and thanks again guys,

andré

[hmsilva]

André,

many thanks for sharing your solution with us.

Cheers
Henrique