Front End Database and Users

[Frothingslosh]

Oh, I wasn't slamming you. Yours is an awesome (and my preferred) approach...when I'm allowed to do it. In fact, I've done it before, but at my current employer (I don't know why I don't say the name, it's not THAT hard to figure out), direct programmatic modification of the registry is verboten unless you're actually in the IT department, and I'm not; I'm in Claims. And I'm fairly certain that most people asking for help here don't have that permission.

 

[The_Doc_Man]

And I'm not slamming you either. I just was not ever IN an environment where I was allowed to do that programmatically. My point was "know your I.T. department - because sometimes what you don't know CAN hurt you."

 

[isladogs]

No problems - I just wanted to set the record straight for the benefit of others ....

As already stated, I lost a few contracts when I stated it was a requirement that specified network folders had to have read/write access for the app to run. In more than one case, the fact that the registry needs to be modified so Access files can run code was enough for them to say a big NO to any use of Access.

However in the majority of cases, I got my way & it made both initial installation & updates a breeze to do with no more than occasional remote support

 

[Frothingslosh]

I just make a point of not telling anyone that using the Trust Center technically alters the registry.

Still, from a contractor's point of view, using the Trust Center is, indeed, a lousy option. It's only feasible from a staff POV.

 

[Galaxiom]

I'm lucky that I have access to our domain admin logins and that it is a small shop with just one other IT worker, the official network admin. Plus the manager is in an office where I can talk to him from my desk.

But I don't have to fool around with the Trusted Locations.

I still develop in mdb and distribute signed mde. Dumbest thing Microsoft did when introducing the accd* format was taking away the ability sign the file. We have our own CA and distribute the certificates through Group Policy. Users don't get any warnings.

 

[The_Doc_Man]

G. - concur. The loss of signing ability was a bummer.