Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-03-2018, 11:24 AM   #1
lekkala
Newly Registered User
 
Join Date: Jan 2018
Posts: 11
Thanks: 9
Thanked 0 Times in 0 Posts
lekkala is on a distinguished road
Upgrading from Access 2010 to Access 2016

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?

lekkala is offline   Reply With Quote
Old 01-03-2018, 06:29 PM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,862
Thanks: 0
Thanked 623 Times in 608 Posts
Ranman256 will become famous soon enough
Re: Upgrading from Access 2010 to Access 2016

an upgrade should not be a problem. They all backward compatible.
all SQL servers versions seem to work. None better than another.
Ranman256 is offline   Reply With Quote
Old 01-04-2018, 01:19 AM   #3
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Upgrading from Access 2010 to Access 2016

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

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
lekkala (01-04-2018)
Old 01-04-2018, 01:34 AM   #4
jleach
Newly Registered User
 
jleach's Avatar
 
Join Date: Jan 2012
Location: New York, NY
Posts: 208
Thanks: 13
Thanked 49 Times in 49 Posts
jleach will become famous soon enough
Re: Upgrading from Access 2010 to Access 2016

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

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Microsoft MVP 2012-2016

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jleach is offline   Reply With Quote
The Following User Says Thank You to jleach For This Useful Post:
lekkala (01-04-2018)
Old 01-04-2018, 05:21 AM   #5
lekkala
Newly Registered User
 
Join Date: Jan 2018
Posts: 11
Thanks: 9
Thanked 0 Times in 0 Posts
lekkala is on a distinguished road
Re: Upgrading from Access 2010 to Access 2016

Quote:
Originally Posted by ridders View Post
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?
lekkala is offline   Reply With Quote
Old 01-04-2018, 05:51 AM   #6
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,921
Thanks: 75
Thanked 1,217 Times in 1,134 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Upgrading from Access 2010 to Access 2016

Quote:
Originally Posted by lekkala View Post
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

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
lekkala (01-04-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Access 2010 RT crashes on Access 2016 machine Tiger955 General 6 06-09-2017 01:23 AM
Upgrading from access 2010 to access 2016 atrium Tables 5 06-26-2016 11:56 PM
Migrating (upgrading) Access 2010 to Access 2013 - issues - suggestions - comments Rx_ General 2 10-20-2015 05:44 AM
Upgrading Access Database from Access 2003 to Access 2010 ladyfrankie General 1 03-31-2013 01:19 AM
Upgrading Access 2010 only jonathanchye General 18 03-25-2011 01:52 PM




All times are GMT -8. The time now is 09:23 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World