Running query on startup

[Bartk]

Hello all,
Been a long time since I've posted something and apparently I've forgotten a bunch of stuff. Ok so here goes. I have a simple db setup and has been working flawlessly over the last coupe of years. However we recently got a new computer here and the file is placed on a network drive. So after got it setup and I'm running it again for the first time to ensure that it still works I'm getting a warning about the query running on startup and I know that it is ok to proceed with running it. I've tried the whole help button and I cannot seem to find out how to enable it to run all the time without me having to hit ok.

I've gone to the create and then hit the macro button to "hide" the notification when it runs. But it just dumps me into the macro page to where I have to design it. Any one who can help me out on this would be a complete life saver. Thanks and god bless

 

[Joe4]

Add the network path to your Trusted Locations in Access and it should work without prompting you.
See: Trust Center in Access 2007 and 2010

 

[Bartk]

Joe,
Thanks for that, I'm on a work computer and they have that locked down for some reason. Says I don't have the security access to do that. Do you know of any other ways to get that accomplished? Any help wold be appreciated. Thanks once again.

 

[Joe4]

How about creating a self-cert and signing the database, then trusting that signature?
See: https://support.office.com/en-my/ar...ignature-5f4ebff3-360d-4b61-b2f8-ce0dfb53adf6

The only other way I know of other than those two things is to lower the security level, which is definitely not recommended. And I imagine if your workplace has Trusted Locations locked down, they may have security levels locked as well anyway.

 

[Bartk]

Yep, still no luck. I might have to get with someone in our IT Dept. here and see what they can do for me. Thanks any ways.