Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-19-2015, 09:20 AM   #1
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,803
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Exclamation Migrating (upgrading) Access 2010 to Access 2013 - issues - suggestions - comments

Next Week, we plan to upgrade Access 2010 to 2013
If anyone has suggestion, approval, questions: please comment.

Lucky me, we distribute with Citrix. This means that it won't matter if Access is even installed on the end-user's workstation.

Since I might be ahead of the curve for most of the people on the forum, thought it might be helpful to discuss any issues or suggestions during the process.

The Application General Description
Access 2010 Front-End has a few local tables. It has about 280 Linked tables to MS SQL Server. MS SQL Server has over a dozen Linked Server to Oracle.
A few dozen SQL Server linked tables are read-only because of extensive business rules derived by T-SQL code on the SQL Server side.
Access Front-End uses a local table with a list of the linked table. Code deletes all linked tables, then uses code to create a DSN_Less ODBC connection using SQL Server Native Client 11.0.
No Access Report objects are used. The Access application uses Excel Object Model Programming to create complex, custom reports and save them on the network.

General Process:
Step 1. For the Citrix Application Server - Office 2013 with the latest SP and Native Client 11.0
Step 2. For Developer's workstation, Office 2013 with exact same SP and Native Client 11.0
Step 3. Open empty copy of Access 2013. Import all objects from copy of Access 2010. Set Start-Up objects and other DB settings to match Access 2010 version.
Step 4. Microsoft 2013 had issues with Themes working correctly. Verify forms, buttons and other interface in 2013 works properly.

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Old 10-19-2015, 10:39 PM   #2
HiTechCoach
Newly Registered User
 
HiTechCoach's Avatar
 
Join Date: Mar 2006
Location: Oklahoma City, OK
Posts: 4,254
Thanks: 8
Thanked 156 Times in 144 Posts
HiTechCoach is a jewel in the rough HiTechCoach is a jewel in the rough HiTechCoach is a jewel in the rough HiTechCoach is a jewel in the rough
Re: Migrating (upgrading) Access 2010 to Access 2013 - issues - suggestions - comment

Quote:
Step 4. Microsoft 2013 had issues with Themes working correctly. Verify forms, buttons and other interface in 2013 works properly.
I have seen this with Access 2007, 2010, and 2013 when Access was used to save a .mdb into the new .accdb format.

I have also found that forms and report hat are having issues with themes can be repaired by saving to a text file and the loading it.

See: Backing up and Restoring Objects
__________________
Boyd Trimmell
Specializing in Accounting, CRM, and Business solutions
Microsoft Access MVP 2010-2015 , aka
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by HiTechCoach; 10-20-2015 at 02:04 PM.
HiTechCoach is offline   Reply With Quote
Old 10-20-2015, 05:44 AM   #3
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,803
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Re: Migrating (upgrading) Access 2010 to Access 2013 - issues - suggestions - comment

I posted a while back that by importing all objects, the 2013 .accdb had a undocumented result. My 150 MB front-end on 2010 dropped to almost half in size..
First I was worried that something had gone wrong. But, the 2013 for our limited testing did seem to work work with all forms. The forms are all vba driven with code update, edits, deletes rather than the built in Access form level recordset.

Even on Access 2010, every so often there seems to be size bloat that the Compact and Repair didn't handle. And, ever so often some event would just cease to work. By creating a new bland Access front-end and importing all objects, thus far has fixed it.
It is probably just a habit of mine at this point.

Your Themes solution using the text file is very useful!

The Scary Thing for me this Halloween will be getting use to the new Access 2013 interface.

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Reply

Tags
access 2010 , access 2013 , citrix , sql server native client

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Migrating split 2010 dbase to 2013 LynnCohen General 2 04-02-2015 04:08 AM
Upgrading to Access 2013 boborr Forms 5 03-19-2015 12:02 PM
Migrating from XP to access 2013... Kees Visser General 1 09-22-2013 04:32 AM
Migrating from Access 2003 to Access 2010 access7 General 5 06-03-2013 05:42 AM
Upgrading Access Database from Access 2003 to Access 2010 ladyfrankie General 1 03-31-2013 01:19 AM




All times are GMT -8. The time now is 06:51 AM.


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

Featured Forum post


Sponsored Links


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