Newly created Access mdb files contain Macros, how do I stop it? gam 05.07.2006 05:04:01 I create a new Access DB using the blank template I create a new table in design view with one column and 2 rows I save the database I try to re-open it and get the following error message: Security Warning Opening "D:\....\test.mdb" This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation. etc.. Everything works fine, but when I try to email the DB to someone, it is bounced by their firewall because of the Macros or Active X components or something. What do I do? Gam I am running MS Access 2003

Re: Newly created Access mdb files contain Macros, how do I stop it? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 05.07.2006 21:14:18 You sure that's why it was blocked, or was it strictly because their e-mail client blocks .MDB files? Try zipping it. You might even try changing the extension from .zip to something else to fool their e-mail client. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "gam" <gam[ at ]discussions.microsoft.com> wrote in message news:A4690FDB-E249-4250-BE6B-AD91E8D743BF[ at ]microsoft.com... [Quoted Text] >I create a new Access DB using the blank template > I create a new table in design view with one column and 2 rows > I save the database > I try to re-open it and get the following error message: > > Security Warning > > Opening "D:\....\test.mdb" > > This file may not be safe if it contains code that was intended to harm > your > computer. Do you want to open this file or cancel the operation. > > etc.. > > Everything works fine, but when I try to email the DB to someone, it is > bounced by their firewall because of the Macros or Active X components or > something. > > What do I do? > > Gam > > > > I am running MS Access 2003

Re: Newly created Access mdb files contain Macros, how do I stop it? "virtualkeeper via AccessMonster.com" <u19024[ at ]uwe> 07.07.2006 19:29:10 Microsoft Outlook blocks any .mdb files by default. You have to edit your h_key in the registry to allow them. I Googled the problem the other day and there was a very easy fix to do; however be aware that you will then have a vulnerability to macros being unleashed on your computer via those files. Douglas J. Steele wrote: [Quoted Text] >You sure that's why it was blocked, or was it strictly because their e-mail >client blocks .MDB files? > >Try zipping it. You might even try changing the extension from .zip to >something else to fool their e-mail client. > >>I create a new Access DB using the blank template >> I create a new table in design view with one column and 2 rows >[quoted text clipped - 20 lines] >> >> I am running MS Access 2003 -- Later, Darrin Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200607/1