If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2000 vs 2007
I am working in a small office configuration (5 employess), and we are all
using one of the Microsoft Server configurations (our IT folks out of LA set it up, and as you will find from this question, I am not a tech guy). We have been using an ACCESS program I wrote several years ago on the 2000 version of Access. At one point our office was upgraded to 2003 without Access, and we kept the 2000 version on our computers and the program rocked on just fine. I recently had a computer crash and my new computer was delivered with Office Professional 2007 - which included Access 2007. However, many, if not all, of the Macros written in 2000 will not work in 2007. I am the only person in my office with Access 2007 but eventually it will all be upgraded. Now my question: Can I install the Access 2000 on my new machine with Office 2007 without the 2000 installation messing up other 2007 programs (Word, Excel, Etc.)? I am assuning I would need to unistall Access 2007 before installing Access 2000? Any help or input would be appreciate. Thanks, -- Kevin |
#2
|
|||
|
|||
Access 2000 vs 2007
There are two answers to your question.
Yes, you can have multiple versions of Access installed side-by-side. And, yes, you should probably install the earlier version first. (Although I've done it out of order and seem not to have experienced any ill effects). One important thing is to make sure that you create a new folder for each version, e.g. Office9, Office12. Also, pay attention to the dialog boxes if you are asked if you want to remove earlier version, and make sure you install only the application you need, i.e. Access. The second answer is really more of another question and that is to wonder whether this might be an opportunity to convert the macros to VBA in the 2007 version, and see if you can't take advantage of the greater flexibility and power of VBA. |
#3
|
|||
|
|||
Access 2000 vs 2007
The macros might work if you put the database in a trusted location.
To do this you will need to click on the Office Button and click options(?). Sorry can't test on this computer. Try the help function and search for trusted location. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Kevin wrote: I am working in a small office configuration (5 employess), and we are all using one of the Microsoft Server configurations (our IT folks out of LA set it up, and as you will find from this question, I am not a tech guy). We have been using an ACCESS program I wrote several years ago on the 2000 version of Access. At one point our office was upgraded to 2003 without Access, and we kept the 2000 version on our computers and the program rocked on just fine. I recently had a computer crash and my new computer was delivered with Office Professional 2007 - which included Access 2007. However, many, if not all, of the Macros written in 2000 will not work in 2007. I am the only person in my office with Access 2007 but eventually it will all be upgraded. Now my question: Can I install the Access 2000 on my new machine with Office 2007 without the 2000 installation messing up other 2007 programs (Word, Excel, Etc.)? I am assuning I would need to unistall Access 2007 before installing Access 2000? Any help or input would be appreciate. Thanks, |
#4
|
|||
|
|||
Access 2000 vs 2007
"Kevin" wrote in message ... I am working in a small office configuration (5 employess), and we are all using one of the Microsoft Server configurations (our IT folks out of LA set it up, and as you will find from this question, I am not a tech guy). We have been using an ACCESS program I wrote several years ago on the 2000 version of Access. At one point our office was upgraded to 2003 without Access, and we kept the 2000 version on our computers and the program rocked on just fine. I recently had a computer crash and my new computer was delivered with Office Professional 2007 - which included Access 2007. However, many, if not all, of the Macros written in 2000 will not work in 2007. I am the only person in my office with Access 2007 but eventually it will all be upgraded. Now my question: Can I install the Access 2000 on my new machine with Office 2007 without the 2000 installation messing up other 2007 programs (Word, Excel, Etc.)? I am assuning I would need to unistall Access 2007 before installing Access 2000? Any help or input would be appreciate. Thanks, -- Kevin |
#5
|
|||
|
|||
Access 2000 vs 2007
|
Thread Tools | |
Display Modes | |
|
|