A way to avoid security question in ACCESS 2007 startup?

[mikey222]

everytime i open my database i have to activate the VB permission but its very tedious for the end users

is there a way to bypass it

cheers

 

[speakers_86]

Add your db to the trust center. Click the MS Office button, Access options, Trust Center, Trust Center, Trusted Locations. Add your db there.

 

[mikey222]

great it worked...thanks for the help...didnt pay enough attention on that configuration...

cheers

 

[KenHigg]

Is there a way to open the trust center if you only have the 2007 runtime version of Access?

 

[KenHigg]

Never mind. I figured out how to modify the trusted locations key directly -

 

[Mike375]

Never mind. I figured out how to modify the trusted locations key directly -

How do you do that Ken. I just started playing Runtime 2007 to run A2003 DB and when the DB is opened in runtime up pops a box etc.

 

[KenHigg]

You ever tinkered with the windows registry?

 

[Mike375]

You ever tinkered with the windows registry?

No, but I am game, I can always format and start again

 

[KenHigg]

Basicly you create a new key in the registry and tell where the trusted folder is.

a. Run the registry editor by doing Start->Run and typing in regedit
b. Navigate to the following folder:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\

c. Highlight the 'Trusted Locations' folder, right click and do New->Key
d. You can name this whatever you like.
e. Then highlight the new key and right click and do New->String Value
f. Name the new String Value 'Path' (without the quotes)
g. Highlight the new 'Path' key entry, right click and do Modify
h. Here type in the path to your new trusted folder something like:

c:\mynewfolder\

Ok to save, close the registry editor and it should work.

Let me know how it goes or if you need screenshots...

 

[Mike375]

Thanks Ken.

I will have a go on the weekend after the New Year along with a couple of other all day and night vigils in Access

Are the DBs you are running on 2007 RT made in A2003 and or A2007.

It was Pat Hatrman that suggested to me that 2007 RT should be OK to use DBs made in A2003. I have tried a few on one of my computers where I removed MSOffice.

Do you know if there is any way to get to the file that I assume/guess installs it. It would be good if you just put the folder Office12 and its contents on someones computer but of course the folder contents on their own won't work.

 

[KenHigg]

I just figured all of this out today so I am a bit green to say the least -

I tried to open a mdb and it looked like it ran ok in 2007 but I'd sure be surprised if there weren't some things that mis-behaved if I put it through it paces.

Other than run the 2007 run executable on the pc I'm thinking the next best thing would be to build the database install file(s) which would just automate some of the things you were doing manually. I'm guessing copying everything over wouldn't work as either the rt exe or install file(s) probably tinker with the registry... ?

 

[Mike375]

I down loaded it a few times and there is some file that extracts. The down load is 56mb and it is listed in Control Panel as 124mb

I have tried a fair with my own person DB and so far all but one thing has worked. The strange part was that is was only a macro action of GoToNextRecord. I have code that extracts/install Word docs embedded in OLE and the macro just goes to the next record and the code runs again. In the RTime it just sat there spinning its wheels and continuing to install the first one in the records

What did suprise was that errors related to macros still brought up the Halt box with the macro name/action. I deliberated changed a few macros so field name spellings etc were wrong.

I have an extremely complex Access to Word and that all worked OK. I uninstalled Office 2003 and then reinstalled without Access. However if MSOffcie is removed then I had problems because of MS Word Library 11 but I changed my code so no refence was needed.

 

[Mike375]

Basicly you create a new key in the registry and tell where the trusted folder is.

a. Run the registry editor by doing Start->Run and typing in regedit
b. Navigate to the following folder:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\

c. Highlight the 'Trusted Locations' folder, right click and do New->Key
d. You can name this whatever you like.
e. Then highlight the new key and right click and do New->String Value
f. Name the new String Value 'Path' (without the quotes)
g. Highlight the new 'Path' key entry, right click and do Modify
h. Here type in the path to your new trusted folder something like:

c:\mynewfolder\

Ok to save, close the registry editor and it should work.

Let me know how it goes or if you need screenshots...

Ken, all worked. Thanks for that.

I suppose there would be a way to automate that. I just did it on Vista Home Basic but will look at XP as well. On the weekend I might have a go at automating it.

I have never been to that part of the computer before but on the surface it would appear that you can only fix the security for a single folder.

As a side note, when I also have A2003 installed, as I do on this computer, then I start the mdb from the folder with right click and Open With and select the A2007 key. For the first opening a box will open saying it can't find the file/folder. I close that and then it goes onto open after configuring for A2007. From the next opening on I just double click the file name and it goes straight through. If I then click the Access key on the tool bar that opens my Access default folder it then goes into configuring for A2003. Is yours the same sort of deal.

I just tried my email system (includes attachments) and that worked fine. I am going to start using it all the time to make things to see any bugs. I have a laptop next to me with Office 2003 and on network so I can make on that and copy across.

 

[KenHigg]

As a side note, when I also have A2003 installed, as I do on this computer, then I start the mdb from the folder with right click and Open With and select the A2007 key. For the first opening a box will open saying it can find the file/folder. I close that and then it goes onto open after configuring for A2007. From the next opening on I just double click the file name. If I then click the Access key on the tool bar that opens my Access default folder it then goes into configuring for A2003. Is yours the same sort of deal.

Hum...You kind of lost me with that one Mike...

 

[Mike375]

Your are up early Ken. In less than 2 hours I can let you know whether 2009 arrived

1) With Office 2003 installed and RT A2007 I go to Explorer and right click on the file name.

2) A menu opens that has Open With and that shows two Access keys and one is obviously A2007

3) I click the A2007 key, a box opens saying the folder/file can't be found. I click Ok and the a box opens "configuring 2007" etc and it goes on to open the DB in RT 2007 (and autoexec)

4) from that point on if double click on the file it just goes straight to A2007 RT and opend the DB

5) If then go to the Access icon for 2003 on the taskbar that brings up "configuring for 2003 etc"

I would like to find out how to avoid having to down load it. From memory the download screen say the file is RuntimeAccess.exe, but whatever it was I culd not find it.I think if you get the file that is down loaded and run that it would do the appropriated extracting/installing.

 

[KenHigg]

Your are up early Ken. In less than 2 hours I can let you know whether 2009 arrived

Call me a simpleton but it still amazes me that we are really on opposite sides of the planet chatting like this -

 

[KenHigg]

Your are up early Ken. In less than 2 hours I can let you know whether 2009 arrived

1) With Office 2003 installed and RT A2007 I go to Explorer and right click on the file name.

2) A menu opens that has Open With and that shows two Access keys and one is obviously A2007

3) I click the A2007 key, a box opens saying the folder/file can't be found.

I'd have to stop right here. What file can it not find? Hum... One thing you may be able to tinker with the file extension association thing. You know where you go in to Expolore->Tools->Folder Options->File Types.

 

[Mike375]

Call me a simpleton but it still amazes me that we are really on opposite sides of the planet chatting like this -

And while you are freezing I am in shorts with the air condition running at full power However, Christmas out here is still shown as a White Christmans in terms of Christmas cards, decorations etc....all in the middle of heat waves.

 

[KenHigg]

And while you are freezing I am in shorts with the air condition running at full power However, Christmas out here is still shown as a White Christmans in terms of Christmas cards, decorations etc....all in the middle of heat waves.

I never thought of that - Thats funny....

 

[Mike375]

I will see if I can atach one of those Print Screen things.

It only happens on the first open of A2007

That worked, but a bir small, it scales it back from 240 k to 99