Access 2000 and Office 2010 living together
Hello we currently are running Office 2000 Pro over a Citrix connection. Our Citrix farm consist of several servers. Users are automatically disseminated to one of the servers when they login.
Users access 4-5 different access front ends connecting to sql server back ends (and some access back ends.)
This weekend the citrix servers are being upgraded from Office 2000 Pro to Office 2010 Standard. The plan is to leave Access at it's 2000 level since it is not part of Office 2010 Standard.
I can't change this plan, it is in motion and is going to happen. I built these access applications and want to try to do whatever I can can to make sure Monday morning is not a disaster for the users trying to use them.
What do I need to do over the next couple of days to make sure my Access 2000 applications will still work ok.... or am I being overly paranoid?
Thanks.
Users access 4-5 different access front ends connecting to sql server back ends (and some access back ends.)
This weekend the citrix servers are being upgraded from Office 2000 Pro to Office 2010 Standard. The plan is to leave Access at it's 2000 level since it is not part of Office 2010 Standard.
I can't change this plan, it is in motion and is going to happen. I built these access applications and want to try to do whatever I can can to make sure Monday morning is not a disaster for the users trying to use them.
What do I need to do over the next couple of days to make sure my Access 2000 applications will still work ok.... or am I being overly paranoid?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Immediately put in for a 1 month vacation starting this Saturday!
This first 'issue' w/b users getting used to the Ribbon. If you have any custom menus/toolbars, by default ... the will appear on the Add-Ins Ribbon.
Next: Trusted Locations. In order for your dbs to 'work', they will need to be in a Trusted Location - which can be added via the Access 2010 UI, or entries can be made directly into the Registry.
Beyond this, it's kind of hard to say, depending on the complexity of the databases, you may or may not run into other subtle issues.
I would suggest looking over the following KBs:
Access 2010 Migration Guide:
http://blogs.msdn.com/b/access/archive/2010/09/07/download-the-free-access-2010-migration-guide.aspx
Upgrading Solutions to Office 2010 with Application Compatibility Tools and Guidance
http://msdn.microsoft.com/en-us/office/ee722033.aspx
Transitioning Your Existing Access Applications to Access 2007 (And A2010)
http://msdn.microsoft.com/en-us/library/bb203849.aspx
Access 2010 specifications
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx
Access 2010 Object Model Changes Since Earlier Versions
http://msdn.microsoft.com/en-us/library/ee836189%28office.14%29.aspx
mx
This first 'issue' w/b users getting used to the Ribbon. If you have any custom menus/toolbars, by default ... the will appear on the Add-Ins Ribbon.
Next: Trusted Locations. In order for your dbs to 'work', they will need to be in a Trusted Location - which can be added via the Access 2010 UI, or entries can be made directly into the Registry.
Beyond this, it's kind of hard to say, depending on the complexity of the databases, you may or may not run into other subtle issues.
I would suggest looking over the following KBs:
Access 2010 Migration Guide:
http://blogs.msdn.com/b/access/archive/2010/09/07/download-the-free-access-2010-migration-guide.aspx
Upgrading Solutions to Office 2010 with Application Compatibility Tools and Guidance
http://msdn.microsoft.com/en-us/office/ee722033.aspx
Transitioning Your Existing Access Applications to Access 2007 (And A2010)
http://msdn.microsoft.com/en-us/library/bb203849.aspx
Access 2010 specifications
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx
Access 2010 Object Model Changes Since Earlier Versions
http://msdn.microsoft.com/en-us/library/ee836189%28office.14%29.aspx
mx
My guess is that you may have some vba "reference" issue, but these can be easily fixed.
But like thinkpads_user, I am concerned with such a big jump (4 version, 12 years)
Some things you could do in Access 2000 (Edit Linked Excel Files "round Trip"), are not possible in 2010.
Office 2010 will "expect" to see Access 2010, ...and perhaps 2007, but it certainly won't be expecting Access 2000.
;-)
In other words, if something breaks, There probably wont be a fix for it from MS.
But like thinkpads_user, I am concerned with such a big jump (4 version, 12 years)
Some things you could do in Access 2000 (Edit Linked Excel Files "round Trip"), are not possible in 2010.
Office 2010 will "expect" to see Access 2010, ...and perhaps 2007, but it certainly won't be expecting Access 2000.
;-)
In other words, if something breaks, There probably wont be a fix for it from MS.
ASKER
Mx- there won't be a ribbon. Access is staying at 2000. No trusted locations or any of that, right?
I have been through all that, before we went to Citrix, and we had a mixed environment at the desktop level (Office 2000 and Office 2007, at that time...)
My concern here is that Citrix will now have Excel, Word , Powerpoint at 2010 levels and Access wtill at 2000 levels. We have already had Outlook 2010 running since February with no conflicts.
I have been through all that, before we went to Citrix, and we had a mixed environment at the desktop level (Office 2000 and Office 2007, at that time...)
My concern here is that Citrix will now have Excel, Word , Powerpoint at 2010 levels and Access wtill at 2000 levels. We have already had Outlook 2010 running since February with no conflicts.
"Mx- there won't be a ribbon. '
Actually, there will ... unless you do 'certain things'.
"No trusted locations or any of that, right? "
Yes ... Trusted Locations if you are working inside the A2010 enviroment, which you will be.
"but it certainly won't be expecting Access 2000."
MDBs work just fine in A2010, for the most part.
RE: Excel - that restriction goes back quite sometime, prior to A2003 at least.
mx
Actually, there will ... unless you do 'certain things'.
"No trusted locations or any of that, right? "
Yes ... Trusted Locations if you are working inside the A2010 enviroment, which you will be.
"but it certainly won't be expecting Access 2000."
MDBs work just fine in A2010, for the most part.
RE: Excel - that restriction goes back quite sometime, prior to A2003 at least.
mx
ASKER
Wow, now I am really confused. The Access 2000 databses are going to open with a ribbon even though there is no Access 2010 installed? How is that possible? aaaaaahhhhhhh
Why don't you set up a test machine and try this? I think I would have been testing before the point of no return. ... Thinkpads_User
ASKER
Set up a Citrix Server? I don't know how to do that. I have tested on a desktop, but that is not the scenario, exacty.
OOPS ... damn, I MISSED you are leaving A2000 in place ... sorry.
mx
mx
ASKER
i know mx, just playing with ya.. :)
@mx
<<OOPS ... damn, I MISSED you are leaving A2000 in place ... sorry.>>
I almost did the same thing. I saw "upgrade" and it wasn't until I re-read the question again that I realized that A2000 was staying in place.
@snyperj,
Just one important note (and this is true any time you have multiple versions of Office installed), make sure they install to a new directory for 2010.
If they want to leave everything with Office 2010 as "default", then un-install Office 2000, then install Access 2000 to something other then the default path (somthing like \program files\O2000), then install Office 2010.
Jim.
<<OOPS ... damn, I MISSED you are leaving A2000 in place ... sorry.>>
I almost did the same thing. I saw "upgrade" and it wasn't until I re-read the question again that I realized that A2000 was staying in place.
@snyperj,
Just one important note (and this is true any time you have multiple versions of Office installed), make sure they install to a new directory for 2010.
If they want to leave everything with Office 2010 as "default", then un-install Office 2000, then install Access 2000 to something other then the default path (somthing like \program files\O2000), then install Office 2010.
Jim.
For environments like this, there's no need to purchase a license of Access 2000 or 2010 for each user. You can use the free runtime version of Access 2010 and give the users all the new functionality in 2010. The most significant drawback of the runtime version is the lack of a spell checker.
This might work with A2010:
http://www.pcesoft.com/Access-Spell-Checker-Tool-Source-Code.html
And if not, then this:
http://www.fmsinc.com/MicrosoftAccess/SpellChecking.html
mx
http://www.pcesoft.com/Access-Spell-Checker-Tool-Source-Code.html
And if not, then this:
http://www.fmsinc.com/MicrosoftAccess/SpellChecking.html
mx
ASKER
I know the run time is an option, and it will likely be a fall back if we have issues.
My concern is that, on my last check, there is no way from the run time interface to set trusted locations, unless this has changed in 2010. I believe the run time I was checking with was 2007 and there was no way to access options.
My concern is that, on my last check, there is no way from the run time interface to set trusted locations, unless this has changed in 2010. I believe the run time I was checking with was 2007 and there was no way to access options.
It's not that hard to set TL's with a simple vbscript. I actually got some help here on EE in another zone, and using a free tool on the internet, I created an .EXE. We send it out via email to users in our group, and one click ... TL's are set. Done.
mx
mx
Or you can just open one of the other Office 2010 products and set the Trusted Location from there.
However, with Citrix, you'll likely need to do this through the Citrix interface/manager, since where those TLs are set will depend on exactly how the Citrix machine/farm is setup. If you have an IT company doing this for you, make sure they're aware that you need to setup TLs in the Citrix environment.
However, with Citrix, you'll likely need to do this through the Citrix interface/manager, since where those TLs are set will depend on exactly how the Citrix machine/farm is setup. If you have an IT company doing this for you, make sure they're aware that you need to setup TLs in the Citrix environment.
ASKER
The last paragraph of LSMConsultings post is the kind of stuff I was afraid of.
No, there is No outside company, just in-house IT blazing a trail. This is why I wasn't opposed to keeping A2000, as long as it works with the rest of the suite in 2010. At least that way I wouldn't have to be concerned with the TL's. The applications are fairly simple, but important, with a significant amount of vba in each.
Citrix is a different world, and pretty much a new world for us. We are still struggling with user printer mappings and such...
I guess this is going to be a fingers-crossed approach for me and hope everything is stable on Monday with regard to the coexistance of A2000 and 2010Word, 2010Excel, 2010PP....
No, there is No outside company, just in-house IT blazing a trail. This is why I wasn't opposed to keeping A2000, as long as it works with the rest of the suite in 2010. At least that way I wouldn't have to be concerned with the TL's. The applications are fairly simple, but important, with a significant amount of vba in each.
Citrix is a different world, and pretty much a new world for us. We are still struggling with user printer mappings and such...
I guess this is going to be a fingers-crossed approach for me and hope everything is stable on Monday with regard to the coexistance of A2000 and 2010Word, 2010Excel, 2010PP....
ASKER
Everything worked with no issues.
>>> What do I need to do over the next couple of days to make sure my Access 2000 applications will still work <-- Set up a test machine and try it. See what happens.
... Thinkpads_User