O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3.11. Convert with Confidence

You can convert to the new ACCDB file format as easily as selecting File Save As. There's 100 percent compatibility with Access 2000 and 2002 file formats and you can even have an MDB and ACCDB version of the same app open at the same time. One hundred percent compatible? Okay, there is a qualifier. Just because the file formats are compatible doesn't mean that the code converts smoothly or is totally supported, to say nothing about little bugs that have thus far escaped detection.

Appendix A covers the issues and processes associated with converting a variety of file formats, including MDEs, secured, and even replicated databases. For now, the best way to know how your applications will be affected is to install Access 2007, open the file, and save it as an ACCDB file type.

3.11.1. Secured Databases

There's good news and bad news—and it's the same news: Everything related to the MDW and user-lever security could be wiped out with just one click. That's fantastic, at least it is for those who don't need or already have an alternate method for enforcing permissions and also have a modicum of restrictions for file access. But the ease of removing the MDW is also risky: Developers and managers especially need to be aware that if someone has Access 2007 and can sign into a secured MDW with sufficient permission, he can merely save the MDB as an ACCDB, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required