Upgrading from Access 2010 to Access 2016 (1 Viewer)

lekkala · Jan 3, 2018

We are upgrading to Access 2016.
Right now we have Access 2010 as front end and SQL Server 2012 as back end.
Access has all the forms,reports and tables are linked to SQL Server 2012, where we have our source tables as well as views on which the queries are written.
What are the steps I should follow and important issues to be focused when upgrading Access 2010 to Access 2016?
Also which version of SQL Server should be best as back end for Access 2016?

Ranman256 · Jan 4, 2018

an upgrade should not be a problem. They all backward compatible.
all SQL servers versions seem to work. None better than another.

isladogs · Jan 4, 2018

One possible issue.
If you have pivot tables or charts in your FE database, these won't work in A2016 as that feature was dropped after A2010

jleach · Jan 4, 2018

There's some more info here in a recent thread on the same topic: https://www.access-programmers.co.uk/forums/showthread.php?t=297552

lekkala · Jan 4, 2018

ridders said:
One possible issue.
If you have pivot tables or charts in your FE database, these won't work in A2016 as that feature was dropped after A2010

Yes we have pivot tables in Excel spreadsheet reports which are linked to SQL Server. Can they be viewed in Access 2016?

isladogs · Jan 4, 2018

lekkala said:
Yes we have pivot tables in Excel spreadsheet reports which are linked to SQL Server. Can they be viewed in Access 2016?

Presumably not
You could try converting to cross tab query/ chart

Upgrading from Access 2010 to Access 2016 (1 Viewer)

lekkala

Registered User.

Ranman256

Well-known member

isladogs

MVP / VIP

jleach

Registered User.

lekkala

Registered User.

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread