Access 2007

[shank]

Not sure where to ask this...

From Access XP 2002 - upgrade to Office 2007....

1) How many of my macros and modules will not work?

2) If I pass an Access 2007 MDB to a user with Access 2002, will it open
without conversion? I see there's a compatibility pack, but so far, it does
not work for the Excel tests I've done.

3) Is there a reverse compatibility chart showing problems posted somewhere?

thanks!

 

[Allen Browne]

Answers embedded.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Not sure where to ask this...

From Access XP 2002 - upgrade to Office 2007....

1) How many of my macros and modules will not work?

Provided you set the database folder as a trusted location, your macros and
code will work as the the previous version.

There are a few gotchas. The ones I am aware of are listed here:
http://allenbrowne.com/Access2007.html#Compatibility

2) If I pass an Access 2007 MDB to a user with Access 2002, will it open
without conversion? I see there's a compatibility pack, but so far, it
does not work for the Excel tests I've done.

Yes. Users with previous versions will be able to use your MDB.

Of course, if you used some of the new functionality, it won't be present
under 2002, and could cause problems. Similar to if you use have an Access
2000 format database in Access 2002 and use the Printer object: users under
Access 2000 will then have problems with the database.

3) Is there a reverse compatibility chart showing problems posted
somewhere?

See the "Features no longer available" in:
http://technet2.microsoft.com/Offic...ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true