Which version to use - Access 07 or 2010 ?

[Emily]

I need to develop a simple DB in either access 07 or 2010. Does anyone have experience using Access 2010?
Is this version stable?
I will be running Windows 07, if I use access 2010 will that be compatible with Windows 07?
Is it downward compatible with access lower version as well?
Any advice or info is much appreciated. Thanks.

 

[boblarson]

1. Access 2010 would be my choice between 2007 and 2010.

2. I believe it is a good, stable product but there is always a risk of bugs being found in any software so it is possible this could happen. But I feel the benefits outweigh the risk of that.

3. When you ask if it is downwards compatible, what are you asking for? Are you asking because you have other users who are using older versions and then you would be developing on 2010 for them? If so, I would suggest that, if you want to use 2010, they use the Access 2010 runtime instead of their lower version Access. Then you don't have to try to figure out what you can or can't use for them and they are assured of it running for them.

4. And yes, it is of course great with Windows 7.

 

[Emily]

Thanks for the advice. Essentially I can just run Windows 7 with Access 2010 and I don't need to purchase Windows 2010 then.
Do you have any comparison chart, links or write-ups between the two versions Access 2007 and 2010? thanks again!

 

[boblarson]

Thanks for the advice. Essentially I can just run Windows 7 with Access 2010 and I don't need to purchase Windows 2010 then.

It would be interesting to see you try to purchase Windows 2010 since that is something that doesn't exist

Do you have any comparison chart, links or write-ups between the two versions Access 2007 and 2010? thanks again!

No, I don't but if you do a web search you should be able to find several (and I would look at several of them, not just one or two).

One of my favorite things in 2010 is the addition of Intellisense into not only Macros but also Queries (in the QBE grid) and in the Builder.

 

[Balder]

Hi

I am in the process of finishing a project i started building using Access 2007.

After the release of Office 2010 i upgraded from 2007. My project was at the time about 60% ready.
After the upgrade the only issue i encountered was when applying themes in forms, but i found a solution to that.
Everything else worked just fine.
I am very satisfied with Access 2010 so far, and find it much easier to work with than Access 2003, that i used for several years.

I am just in the process of converting a small system from Access 2003 to Access 2010. So far it goes well, i hope that only minor changes to the forms will be necessary.

Good luck.

Balder
Norway

 

[Emily]

Opps! You are right no Windows 2010. What was I thinking! sorry!
thanks for being such a great help.

 

[boblarson]

Opps! You are right no Windows 2010. What was I thinking! sorry!
thanks for being such a great help.

No problem.

I wish you the best in your endeavor. And remember we're (the entire AWF family) to help when you need it. I really think when you get going with it that you are going to like 2010 a lot. They have made several improvements over 2007 (including providing a real programmatical way to minimize the Ribbon where in 2007 we had to resort to SendKeys).

 

[vbaInet]

They have made several improvements over 2007 (including providing a real programmatical way to minimize the Ribbon where in 2007 we had to resort to SendKeys).

There was an API I came across that did that. I used it, made some modifications and it worked. It wasn't really minimizing but rather decreasing the height of the ribbbon. I got rid of the idea for some reasons

 

[boblarson]

Now they have an actual programmatical way to do it. So that is nice. Also I like 2010's ability to do modifications to the existing Ribbons without using XML or an external tool. You still have to do that with your own custom Ribbons but modifying existing ones are a breeze now.

 

[vbaInet]

There's a UI for making ribbon modifications? I'm guessing you still have to program the buttons?

 

[ghudson]

No problem.

I wish you the best in your endeavor. And remember we're (the entire AWF family) to help when you need it. I really think when you get going with it that you are going to like 2010 a lot. They have made several improvements over 2007 (including providing a real programmatical way to minimize the Ribbon where in 2007 we had to resort to SendKeys).

You can simply hide the ribbon in Access 2007... DoCmd.ShowToolbar "Ribbon", acToolbarNo

Not sure if that still works in Access 2010 since I do not have it. Can anybody test that for me? Thanks!

 

[vbaInet]

ghudson, I think he means minimize as opposed to hiding.

 

[boblarson]

Yes, I mean minimize, not hide.