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

 

[Pat Hartman]

Somehow, you need to create new trusted locations which unfortunately, I can't help you with. If you do succeed, please post your solution.

An alternative is to sign the code. Without a "real" certificate, the users will still be asked to confirm on opening the database but once they accept your "certificate", they won't be asked again. This has the added advantage that if someone mucks with the database, the certificate gets deleted.

BTW, delivering the app with the runtime engine will NOT prevent anyone who has the retail version from opening your app in design view. So this is not an effective method of blocking someone out. You will need to do a lot more work with locking down the navigation pane to acheive something akin to ULS.

 

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

 

[Pat Hartman]

That first link points to a thread about atheism.

 

[Pat Hartman]

I know how to fix trusted locations PC by PC. The issue is how to fix them for the whole community which as you say is most likely an SA issue.

 

[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