Work uses MS Access 2007 should I.... ?

CaptinsQuarters

New member
Local time
Today, 03:50
Joined
Apr 26, 2012
Messages
4
Hi I am looking for some input from people on weather I should get MS Access 2010 or follow what work has and get 2007. Most of my DBs that I create is for work so that is mainly why I was thinking about 2007. But if I stick with VBA it shouldn't be that big of an issue should it?

Thanks,
Capt'n
 
I you are spending your money, I would go with 2010.

You may not notice any issues with the difference. Both 2007 and 2010 use accdb, if that is the file type work has.

My fear would be work will upgrade and you will be left behind.

Unless there is a cost saving in buying 2007, go for 2010.
 
Never buy an old version of an application unless you are a developer and must maintain separate testing environments. It is just a waste of your money. In fact, A2010 will soon be an "old" version. I think a new version of Office is coming out at the end of the year. Access is backward compatable and so it allows you to develop with A2010 and run in A2007 or even A2003 and earlier with the .mdb format. Your only problem is to avoid using newer features. If you are using the .mdb format, Access won't let you use features that are not backward compatable. Since 7 and 10 use the same file format, you have to be more careful yourself. If you "try out" a 10 feature, your database will never be able to run in 7 so you have to avoid that at all cost. Once you've set some internal switch, there is no way to unset it. You would need to create a new empty database and import all the "7" objects and make sure you don't take any "10's"
 

Users who are viewing this thread

Back
Top Bottom