Hi Powel,
going from 2007 to 2010 is easy -- going back to 2007 from 2010 is where the issues are. Once you compact/repair a database with 2010, then 2007 can't read it anymore. If you do need to take the databae backwards, expost to a blank accdb that was made with Access 2007.
It would be best to decompile and the compile in the new environment
~~~~~~~~~ Decompile ~~~~~~~~~
if you have odd behavior, backup your database and then decompile it
make an make a "generic" decompile icon where the next database you open will be decompiled... use this as the target:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /decompile
if your Access program is not located in the directory specified, make the appropriate substitution
the next database you open will be decompiled... you can verify this by going to the design view of any module -- Compile will not be gray, it will be available
then, compile the database
then, do compact/repair
'~~~~~~~~~ ~~~~~~~~
to make a Decompile icon:
Open Windows Explorer
(right-click on [Start], choose 'Explore'
scroll to the top of the left pane
right-click on Drive C:
choose --> Search
look for -->
MSACCESS.EXE
once you see where the program is located, navigate to MSACCESS.EXE using Windows Explorer
then right-click on MSACCESS.EXE and choose -->
SendTo > Desktop (create shortcut)
then, right-click on the desktop icon you just made and choose --> Properties
1. click on the 'Change Icon' command button -- so it doesn't look like a regular Access icon (I use the 2 inerlocking circles one screen to the right on the top row)
2. click in the Target textbox
press the [End] key to move to the end of the line
then, add this to the end of the target -->
/decompile
Warm Regards,
Crystal
Microsoft MVP
remote programming and training
Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: "powelldddd
Subject: [MS_AccessPros] Access 2010 backwards compatibility
Are there any issues with the backwards compatibility of 2010 with 2007? My company is going to upgrade and seems concerned about issues like this.
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar