switch /compact on bat file not running on 2007

[Jimbo213]

Under Access 2003 our .bat file was working just fine at midnight daily.
Then company upgraded to Access 2007.

All the .bat file paths corrected for Access 2007 [path office12 instead of
office11]

..BAT file ends in /user "xxxx" /pwd "xxxxxx" /excl /compact

The compact.bat file starts running at midnight but gets stuck [we think] at
the annoying security message waiting for somone to press "open"

Is there a switch that can overcome that security message.
I do not want to sign the database every time we make a change.

Thanks for your reply & assistance.
Jimbo213

 

[Clifford Bass]

Hi,

How about making the location of the access database a trusted
location? Office button, Access Options, Trust Center, Trust Center Settings
button, trusted locations.

Clifford Bass

 

[Jimbo213]

Tried that. I have ADMIN rights on the db but the Add New Location button
is grayed out. I work for a huge corporation - I'm thinking that there is a
OFFICE ADMIN rights setting that I don't have.

Thanks for your reply & assistance.
Jimbo213

Hi,

How about making the location of the access database a trusted
location? Office button, Access Options, Trust Center, Trust Center Settings
button, trusted locations.

Clifford Bass

Under Access 2003 our .bat file was working just fine at midnight daily.
Then company upgraded to Access 2007.

All the .bat file paths corrected for Access 2007 [path office12 instead of
office11]

.BAT file ends in /user "xxxx" /pwd "xxxxxx" /excl /compact

The compact.bat file starts running at midnight but gets stuck [we think] at
the annoying security message waiting for somone to press "open"

Is there a switch that can overcome that security message.
I do not want to sign the database every time we make a change.

Thanks for your reply & assistance.
Jimbo213

 

[Clifford Bass]

Hi Jimbo,

Are you logged in as a Windows administrator of the computer itself?
That might make a difference.

Clifford Bass

 

[Jimbo213]

I have "local admin" rights only. There are undoubtedly other ADMIN rights
that I don't have.

Is there another way to skin this cat ?

Thanks for your reply & assistance.
Jimbo213

Tried that. I have ADMIN rights on the db but the Add New Location button
is grayed out. I work for a huge corporation - I'm thinking that there is a
OFFICE ADMIN rights setting that I don't have.

Thanks for your reply & assistance.
Jimbo213

Hi,

How about making the location of the access database a trusted
location? Office button, Access Options, Trust Center, Trust Center Settings
button, trusted locations.

Clifford Bass

Under Access 2003 our .bat file was working just fine at midnight daily.
Then company upgraded to Access 2007.

All the .bat file paths corrected for Access 2007 [path office12 instead of
office11]

.BAT file ends in /user "xxxx" /pwd "xxxxxx" /excl /compact

The compact.bat file starts running at midnight but gets stuck [we think] at
the annoying security message waiting for somone to press "open"

Is there a switch that can overcome that security message.
I do not want to sign the database every time we make a change.

Thanks for your reply & assistance.
Jimbo213

 

[Clifford Bass]

Hi Jimbo,

You can add them directly to the Registry. First close out of Access
if it is open. Standard warning regarding editing of the Registry: DO THIS
AT YOUR OWN RISK. Directions for Windows XP. Other versions would be
similar. Go to the Start menu and choose Run. If Run is not on your menu
let me know. Type RegEdt32 and click OK. Locate the
"HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations" key by expanding each branch as indicated. Expand the Trusted
Locations key also. Take a note of the existing location names (i.e.
Location0, Location1, Location8). Add a new key by right-clicking on
"Trusted Locations" key and choosing New and then Key. Name it Location
followed by an unused number (i.e. Location2). Add a new DWORD value to the
new location by right-clicking on the new location key and choosing New and
DWORD Value. Give it the name of AllowSubfolders. If you want to allow
subfolders to the main folder you will be specifying, double-click on it and
change its value to 1. Then add a new String Value. Name it Path.
Double-click on it and enter the path to your Access file. Close out of the
Registry Editor and test.

Another thing to try would be to disable all macro warnings. If you
cannot do it in the Trust Center Settings, you can change it in the registry.
In the Security key above the Trusted Locations key you should find a DWORD
value named VBAWarnings. While not in Access change its value to 1.

Hope that helps,

Clifford Bass