Open MS access with batch file in design mode

  • Thread starter Thread starter Addy
  • Start date Start date
A

Addy

Hello there,

I have designed a database which opens in the compiled mode. Now when
you press the shift key it will open in design mode.

I want to open in design mode with a batch file. I have tried the
following code.

z:
CD\MED_SERVICE\Manpower
ManPower.mdb /x

It still opens in the compile mode. please let me know what syntax to
use.
 
Hi there,

Basically I will use the batch file to run some macros. Can I still run
the macros without pressing the shift key?
 
Hi, Addy.

Yes. But your startup options will still run unless you press the <SHIFT>
key while opening the database. Apparently, that's what you want when it's
set up for the users ("compile mode," as you called it). If you press the
<SHIFT> key while opening the database, it will be set up for development
("design mode," as you called it).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Ok maybe I should be more clear on what I want.

The batch file will be run nightly to copy csv files into tables. This
way the database will be kepy current. I have made a macro for doing
this, and the macro will be run via a batch file.

Now the same database also has data entry forms. When the user opens
it, the startup runs those forms and nothing else. I have hidden
everything else. I dont want to user going to play around with the
tables, queries and the macros.

This is why I wanted to go in design mode with the batch file so that
it has access to the macros. Is there a better way to do this?

I
 
Hi, Addy.

If you use a batch file to automate this, then the startup options are going
to execute. If you want to use a command-line switch when opening the
database file, then you'll have to tell the operating system not to use the
"don't make me think" method of opening files. If you check your file type
settings, you'll find that the default option is to open the database file
using the "C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
executable (if you're using Access 2003) without any command-line arguments
(options). So if you "tell" Windows to open the MDB file with a batch file,
Windows shortcut, or in a DOS shell and only provide the file name, all you
get is the "don't make me think" option, so any command-line switches will
be ignored.

If you want to execute a macro that is stored in an MDB file, then the
syntax is as follows (watch out for word wrap, as this is all one line):

"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe" C:\Data\MyDB.mdb
/x mcrOpenMainForm

And don't put any spaces in the path, file name or macro name, because that
means "that's the end of this parameter and the next parameter follows."

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top