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.
ClaudeWalkerAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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
 
SStoryConnect With a Mentor Commented:
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
 
ClaudeWalkerAuthor Commented:
Any ideas on why its not running that Macro with this modified batch?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.