Access 2007, 2010 or 2013 upgrade

[Mcfestoe]

Hi

I have just joined after searching for Access 2013 reviews and this site came top, so i thought i would ask the question here.

I have a an Access 2003 db which has been great for years, my PC died and the new one came with Access 2007 on it, now my 2003 isnt compatibal, the tables are there but things like the switchboard on any buttons on forms that i created have disappeared.

My old db was liked to my mobile phone and i could query a table and get results to my phone using another program which sat in the middle.

I was thinking of getting a copy of Access 2013 and starting again making it better, but i found alot of posts from people not liking the 2013 version, is it really that bad ?

 

[Pat Hartman]

Welcome Aboard
Access 2007 should run your A2003 database without a problem.

There is no specific phone interface for Access. You need to rely on 3rd party tools. Check your tool to see if it supports databases in .accdb format or if you have to stay with .mdb.

 

[Mcfestoe]

Thanks for the welcome.

The 3rd party link i use is creativitycorp.com/mds it says it links to Industry standard ADO database support, i dont know Access 2013 will it be supported?

Many Thanks

 

[Pat Hartman]

Each database engine requires a separate ODBC driver and as long as they are using ODBC, there should be support for ACE (the .accdb database engine).

I am using A2013 at one of my clients. Except for looking different visually, I haven't seen any real differences from A2010 but I haven't spent a lot of time exploring either. I think the Access team pretty much left the client/server stuff alone and concentrated on building the web support. The complaints you're seeing are probably pointed toward the web stuff and how it is restricted to macros and so can't really do everything the client/server database can do. One notable difference is you have no ability to automate any of the other Office products since you have no programming language. If you decide to try out the web app, you might like it. People who have tried it say if your app is very simple, Access is relatively quick and easy to create a web app. However, it comes with the baggage of Sharepoint. You MUST use sharepoint as the framework so that means you either have to create your own Sharepoint site or pay a monthly subscription to someone else.

 

[Estuardo]

G'd Afternoon,
In my opinion, unless you have reasons to get the 2k13 version, you may want to keep your 2k7 or move to 2k10.
The 2k13 is more web integrated as for desktop almost the same.
G'd luck