By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,046 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,046 IT Pros & Developers. It's quick & easy.

Access 2000 running in Office 2007, possible?

P: 3
I have Office Professional 2000 but would like to upgrade to Office 2007 (Home/Small Business edition) which does not include Access 2007, this because I am buying it myself, and can't afford Office Pro 2007, especially for two computers. However I would like to keep the Access databases I have. Does anyone know if it possible to Keep Access 2000 running in an Office 2007 environment? Or will installing Office 2007 kill off all parts of a prior installation even if that old component is not present in the new install?

I am using Windows XP Professional and have little interest (at least at present) in upgrading to Vista.

Thanks for any information.
Jun 21 '07 #1
Share this Question
Share on Google+
6 Replies


puppydogbuddy
Expert 100+
P: 1,923
I have Office Professional 2000 but would like to upgrade to Office 2007 (Home/Small Business edition) which does not include Access 2007, this because I am buying it myself, and can't afford Office Pro 2007, especially for two computers. However I would like to keep the Access databases I have. Does anyone know if it possible to Keep Access 2000 running in an Office 2007 environment? Or will installing Office 2007 kill off all parts of a prior installation even if that old component is not present in the new install?

I am using Windows XP Professional and have little interest (at least at present) in upgrading to Vista.

Thanks for any information.
See this link for an excellent analysis of the good, the bad, and the ugly of 2007. Click on the hyperlink that says "Compatibility"

http://allenbrowne.com/Access2007.html
Jun 21 '07 #2

P: 3
Thanks for the link. If I am reading the info correctly, Access 2007 can co-exist with an earlier verson, albeit not happily. By inference, it sounds as though installing Office 2007 would not wipe out an installion of Access 2000, although this is not explicitly addressed.
Jun 21 '07 #3

puppydogbuddy
Expert 100+
P: 1,923
Thanks for the link. If I am reading the info correctly, Access 2007 can co-exist with an earlier verson, albeit not happily. By inference, it sounds as though installing Office 2007 would not wipe out an installion of Access 2000, although this is not explicitly addressed.

cmking,
yes, 2007 can coexist with an earlier version as per the following excerpt from the link I gave you.....however, you must select the option to run the the 2007 version using Access 2000 file format. And there are problems you will have to deal with. As always, make sure you have your present datababse backed up before you try implementing 2007.

Excerpt from the link:

Access 2007 can natively work with MDB files in Access 2000 format or Access 2002/2003 format. It will modify those files, e.g. adding new hidden system tables (such as MSysNavePaneGroups) and properties (such as UseMDIMode), but the files still work in the old versions.

If you install Access 2007 along with previous versions, you may find that, over time, help begins disappearing from the previous versions. For example, if you place the cursor in a property/method in code (such as Visible) and press F1, you get a completely blank window (no content.)

Annoyance: If you have multiple versions of Access on your computer, Access 2007 runs an installation again to re-register itself each time you switch version. Even on a fast computer, this delay is tedious - almost long enough to make coffee. Some earlier versions (such as 2003) also re-register themselves when you start them after using Access 2007.
Jun 21 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
Did I misread the oringinal post? You're not talking about installing Access2007 but rather Office 2007, correct? Anything is possible with Micro$oft products, but this shouldn't prove any problem at all.
Jun 22 '07 #5

P: 3
Did I misread the oringinal post? You're not talking about installing Access2007 but rather Office 2007, correct? Anything is possible with Micro$oft products, but this shouldn't prove any problem at all.
Correct, I am talking about keeping Access 2000 with an installation of Office 2007 Home Edition which does not include Access 2007.
Jun 22 '07 #6

puppydogbuddy
Expert 100+
P: 1,923
Correct, I am talking about keeping Access 2000 with an installation of Office 2007 Home Edition which does not include Access 2007.
Just became aware of one potential problem. As I understand it, you will need to create a certificate for yourself in order to run an earlier version of Access with Office 2007. If you have not 'self certified' your database with a trusted certificate. Office 2007 will not run code that has not been certified. See this link:

http://office.microsoft.com/en-us/ac...397921033.aspx
Jun 22 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.