office 2003 Access

[Guest]

Why does office 2003 Access still use the (access 2000 file format) and it
also shows a security warning before it opens.

I have previously had Office 2000 & XP on my system and have taken them out
to load office 2003

 

[Allen Browne]

Access 2003 can natively use the 2000 format or the 2002 format.
Chose your preference under:
Tools | Options | Advanced | Default File Format

Regarding the choice, note that:
- You cannot create an MDE unless you use the 2002 format.
- An MDE created by 2003 does not work in 2002, because the binaries are
different.

Agreed that it is really stupid to be warned against opening your database
every time you open it. To avoid this, change your macro security setting:
Tools | Macro | Security | Low
If you do not see that menu option, right-click the toolbar area, customize,
and reset the Menu Bar.

For more information, see:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

 

[Guest]

The only problem with setting the Security level to LOW is it saying not
recommended it is not safe?

 

[Rick Brandt]

The only problem with setting the Security level to LOW is it saying not
recommended it is not safe?

It is exactly as "unsafe" as every other version of Access ever released.

Microsoft over-reached on this (IMO). It is reasonable to be suspicious of a
Word doc that contains macros because a "document" should seldom have a need of
them. It is somewhat less suspicious for an Excel file to contain a Macro, but
I can see where the warning has some value.

Access is used to create "Applications". By definition they "do" stuff and any
Access app beyond the most basic of lists will have Macros and/or VBA code in
it. To have a warning that says "Beware! this application contains Macros/Code"
is just plain stupid. This would be the same as having a warning every time you
open Explorer that said "BEWARE! this program can be used to delete/alter files"
Well duh!

 

[Allen Browne]

The message is misleading and inappropriate.

Setting security to Low puts you in exactly the same position as any other
user that uses Access 2002, 2000, 97, 95, 2, 1, or 1.1. Unless you are
accepting Access databases from unknown people, this message is a farce.