[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Default Programs

I have a batch file that I created to open an access database.  start /MIN msaccess.exe "S:\DATABASES\In Out Board\FrontEnd_IOBoard.mdb" /x mcrNormalStart

The problem is that it is supposed to open with Access 2003 but it is open with Access 97.  This all happened because we installed a program where the front end was programed with Access 97.

For all of the machines I just right clicked the mdb and pressed open with and picked the MSAccess.exe 2003 file.  This works for all of the databases opened by double clicking.

The one opened with the batch file always opens in Access 97.  

How can I get the batch file to open the correct version of Access?

Thanks,
JOe K.
0
ClaudeWalker
Asked:
ClaudeWalker
  • 4
  • 3
2 Solutions
 
SStoryCommented:
Instead of saying msaccess.exe, give it an absolute path to the correct one.
probably
C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe

Be sure to enclose it in " "
0
 
Rey Obrero (Capricorn1)Commented:

on this line

start /MIN msaccess.exe "S:\DATABASES\In Out Board\FrontEnd_IOBoard.mdb" /x mcrNormalStart


change msaccess.exe to  

    "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe"

start /MIN "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "S:\DATABASES\In Out Board\FrontEnd_IOBoard.mdb" /x mcrNormalStart
0
 
ClaudeWalkerAuthor Commented:
Any ideas on why its not running that Macro with this modified batch?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rey Obrero (Capricorn1)Commented:
are you getting the Convert/open database message when you open the A97 db in A2003?


see this link
How to suppress the Convert/Open Database dialog box when you open an Access 97 database
http://support.microsoft.com/default.aspx?scid=kb;en-us;824260
0
 
ClaudeWalkerAuthor Commented:
No, I am not getting that message.  It is opening fine accept in the wrong version of Access (with the toolbars suppressed).

Now its opening in the right format with the batch file but the macro is not running.  
0
 
Rey Obrero (Capricorn1)Commented:
can you try this

start /MAX "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "S:\DATABASES\In Out Board\FrontEnd_IOBoard.mdb" /x mcrNormalStart
0
 
ClaudeWalkerAuthor Commented:
Still Nothing.
0
 
ClaudeWalkerAuthor Commented:
I found a work around and ended up just getting rid of the batch file altogether.  

Thanks for your efforts,
JOe K.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now