A way to avoid security question in ACCESS 2007 startup?

[KenHigg]

So is the Viper mdb in the folder the error message shows?

 

[Mike375]

So is the Viper mdb in the folder the error message shows?

Yep, Viper.mdb in \ViperResides.

But it will happen with any .mdb in any folder BUT only on the first opening of file with A2007 RunTime. However, if I run 2003 then the A2007 goes trhough that for the first opening.

I have not yet tried the RT 2007 on my XP machines but will do so on the weekend.

 

[KenHigg]

Hum... It's a mystery to me. Don't know where to start...

 

[Pat Hartman]

Hi Guys. Happy New Year!!!! I recently acquired the same problem Mike is experiencing except that mine is happening with A2003. If I double-click on a file to open it, I get an error message that the database file can't be found. However, if I open Access first and then use the Open file dialog to open a database, no error message occurs. I am assuming that this annoyance was caused by some Vista or Office update that was recently applied and hopefully will go away soon.

 

[Pat Hartman]

I forgot to attach the picture

 

[shadow9449]

Hi Guys. Happy New Year!!!! I recently acquired the same problem Mike is experiencing except that mine is happening with A2003. If I double-click on a file to open it, I get an error message that the database file can't be found. However, if I open Access first and then use the Open file dialog to open a database, no error message occurs. I am assuming that this annoyance was caused by some Vista or Office update that was recently applied and hopefully will go away soon.

Pat:

Are you running the database locally or over a network? IE7 sometimes blocks Office traffic over the network unless you go into your browser, select Tools > Internet Options > Security > Local Intranet > Sites > Advanced and then enter the network path to the database.

SHADOW

 

[Pat Hartman]

Locally and this just started within the past two weeks. When A2007 has control, double-clicking on a database just opens it normally. When A2003 has control, I get the message but the database opens fine.

My client was getting this message earlier this year but in his case, the database didn't open. It turned out (after a call to Microsoft) that his path name was too long and once he shortened the path to the database, the message went away. As you can see, my path name is not too long so this is a different problem.

 

[Mike375]

Hi Guys. Happy New Year!!!! I recently acquired the same problem Mike is experiencing except that mine is happening with A2003.

Pat, Happy New Year. You want to be careful opening any attachment I put up as a loose macro might drop out

 

[raghuprabhu]

First of all Wish you all a Very Happy New Year!

Now the problem. Could be related to this thread.

I recently got a new computer with Access 2007. It took a bit to get used to Access 2007. I designed a database and had a few lines of VBA on each of the form. I compacted the database and the VBA code has vanished! The forms are working but the code is not visible! I can not view the code! Please tell me what is happening?

Thank you

Cheers
Raghu Prabhu Melbourne

 

[llaadd]

hi guy's, when using access runtime on a PC, if i want to stop that security I enter the location in the registry as shown in an earlier post, but my database is stored on a server, so how to I enter the location of that?

I tried entering the path as "\\TheServer\My Data\" but it still shows the error, I also have the above server location mapped as a virtual Drive "S" so I tried entering "S:\" but this does not work either.

Any idea's anyone?

thanks

 

[martino954]

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...

Fine! this was my problem! But I never used windows registry: which editor have I to use? and how to enter? have you any screenshots to learn?
Thanks
martino