Access 2003 question

[AndyShuter]

I have just upgraged to Office 2003, and find that when I run an application I get a "Security Warning" question, which I then have to click "Open" before I run my program. I there a way I can disable this feature?

Regards

Andy

 

[Kevin_S]

I have just upgraged to Office 2003, and find that when I run an application I get a "Security Warning" question, which I then have to click "Open" before I run my program. I there a way I can disable this feature?

Regards

Andy

Andy -

Unfortunitly you have just found the number one major problem with Access 2003. Due to the ever-growing increase of virus and bug attacks Microsoft has determined that it now needs code certification on MS Access Databases (or any programming that runs macros/vb). The way to keep the message asking for verification to run from poping up everytime you open a db is to have a certification file on your server that basically informs to OS that the file is ok and not malicious. Search the MS kb articles for Access 2003 verification and certification for more info.

HTH,
Kev

 

[Mezzwit]

I'm assuming you're meaning the warning to DL and install MS Jet 4.0 SP 8. If you click ok (or yes, whatever) you can click on Tools, Macro, Security and change it to Low and it won't ask you everytime you open a DB.

This worked for me, hope this helps.

-Mezz

 

[Kevin_S]

I'm assuming you're meaning the warning to DL and install MS Jet 4.0 SP 8. If you click ok (or yes, whatever) you can click on Tools, Macro, Security and change it to Low and it won't ask you everytime you open a DB.

This worked for me, hope this helps.

-Mezz

Mezz-

That works as a work-around but you shouldn't have to ask clients to do this... Bad design on MS part if you ask me...

Kev

 

[mathisjay]

I am trying to disable this warning also. I don't see a Security option under Tools > Macro. Any thoughts?

 

[Kevin_S]

Search the MS kb articles for Access 2003 verification and certification

 

[mathisjay]

Ok, I was able to find how to add the Security option back to the menu.

However, if I package this up and send it to a customer, are they going to have to do the same thing? There is no way they are going to be able to figure that out...

Is there any way to set the registry key myself with the installer program that comes with Visual Studio Tool for the Mocirsoft Office System (Access Develop Extensions)?

 

[kbrown]

I just upgraded to Access 2003 also and had the same issue. My IT person found the following solution for use in our office, but I don't think it will work for distribution to clients: Using SelfCert to Create a Digital Certificate for VBA Projects (MS Knowledge Base Article - 217221). There is a reference to using a certification authority to create an authenticated certification for distribution purposes.

 

[Dan_T]

Sorry to jump in on your thread but to package Access 2003 up am i right in saying you need to purchase the Visual Studio Tool for the Mocirsoft Office System (Access Develop Extensions)?

Any help regarding this issue will be greatly appreciated.

Dan