VBA to check Version and Supress safety warning Dailog of Access

[Irshad Alam]

We are using mdb designed in MS Access2000 on share basis.

The user using MS Access2000 has no prompt of safety warning But the user
using MS Access2003 is getting the prompt of safety warning dailog every time
he is opening the mdb.

I view some help while searching via internet, that found solution to do it
manually by making it low security.

My requirement below which I want to do it via VBA code which will run by
AutoExec Macro:
- To check the current version of Access installed on the user PC - IF it is
above Access 2000 then it will run the code to supress the warning dailog
otherwise Not. The code should also make no effect to the Access 2000 user.

Advice awaited.

Regards

Irshad

 

[Daniel Pineault]

Sorry to burst your bubble, but you cannot get rid of that warning at startup.

Well, I say that without knowing what warning you are talking about. There
are warnings that can appear because the pc is not carrying the latest
updates, but the is also a basic startup warning that always remain.

One cannot use vba to change the security settings, that would kind of
defeat the purpose of security!?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Irshad Alam]

Dear Sir,

Thank you for your advise.

While searching more I found a link, which is not clear to me as I am new in
VBA, please check if you can help me by advising if it can be used for my
requirement :

http://www.accessmvp.com/JConrad/accessjunkie/macrosecurity.html

Specially option Number 9

Best regards.

Irshad

 

[Douglas J. Steele]

Why not try it and see whether it works, instead of having to wait for
someone to respond?

(Yes, it should work, or else Jeff wouldn't have posted it!)