Recent content by JamesR

Thanks I'll give that a read My file is a .mdb so might be a little different

It does seem like a cert issue but the certs are issued by the IT security, it's not a personal one, so you would like to think that they would work Once signed the file works but move the file or copy it and the error is thrown up

I wish it was that easy, trusted locations is disabled by the group IT policy. The main thing is why does access think the certs have been tampered with, I have attached a copy of the error

Hi Folks, I posted previously about my companies policy to ban all macros/VBA Anyway the current solution was to issue a certificate to myself so I can sign the VBA code and the database should work as normal. The database was stored on a file share and each user took a copy and ran it locally...

Your 2 pennies worth makes sense but I am so far removed from the senior decision makers in the company. I have lobbied various managers on this but it's a no win.

We tried that but out IT helpdesk is outsourced so they were not too bothered

They must have enabled something else on the policy side because even when I delete all macros from the DB it still will not run. The user will still get the warning " Some active content has been disabled. Click for more details..." This option is now greyed out and the user is unable to enable it

I haven't tried it but once it contains VBA then it will be blocked. All laptops in the organization are being upgraded to Win 10 and the trust center options will all be disabled by default and end users will not be able to change them

I share your opinion but this new policy has the backing of the senior management so that's a no win situation

The argument given by IT is that VBA can be used by hackers to gain access to internal systems. A large organization, who shall remain nameless, was hacked with this method. An employee opened an excel attachment which contained a malicious macro, this then started an encryption process of all...

Thanks, I am well aware of that but my IT department will not allow them

Hi all, The company I work for has taken the step to block all VBA/macros because of the risk to IT security. This will have a massive impact on any excel/access users. I look after a DB that is used daily by 50+ people, it spits out large text files based on users inputs The solution they are...