Yet a Major Trusted Location PROBLEM!

[jepoysaipan]

Hi guys,

This is the really big frustration I had so far using Access 2007, I converted all the applications I created in Access 2K3 to Access 2007 because of the free deployment feature, since I mentioned on my previous posts that the "new guy" then always messing around my code.

So everything went fine, thanks to you guys for helping me a lot on my posts and earned merits on my works . Not until late last week they upgraded our server changes all the volume drive re-map all the folders and "BOOM" application error....cannot find the BE.

I tried to re-map the network folders ever since Monday, but can't seem to work at all since it was looking for the volume drive of the old server.

Well, figured out that I do need to re-deploy the application and re-install every FE on workstation but It will be bloody.

My question, Is the "Trusted Location" problem had been decoded? since I spend every night searching for this solution coz I was thinking it would hit me with this problem, and it did!

Hoping that for those who decoded the problem care enough to share.

Thanks a lot!

Jeff

 

[georgedwilkinson]

Just noticed this...thanks for reviving it, Pat.

Bob has the solution to both on his web site:
To manage your Front Ends (make re-deployment easier):
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspxhttp://www.access-programmers.co.uk/forums/showthread.php?p=696993&highlight=Aspergers#post696993

Here's how to fix trusted locations (no automation to this):
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

Making trusted locations universal (for all users) is a system/network administrator job. Unfortunately, most SAs hate Access applications because they can't control them.

 

[jepoysaipan]

Hi guys,

Thanks for the info. I am aware of Bob's FE & BE tool, but going back to my problem I do in need of a utility somewhat like the applications developed using VB.net or other programming languages which has this "Global Installation" that whenever there's a problem with the application simply re-install the software upload the back-up and you're back on track.

I know it's a far cry from Access but I do believe someone out there given the time and "generosity" will do share his solution.

FYI the link on Bob's FE update goes to the "Atheist" thread.

Thanks again guys!

 

[georgedwilkinson]

FYI the link on Bob's FE update goes to the "Atheist" thread.

Sorry 'bout that...I fixed it in the post but here it is again (correctly, we can only hope):
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx