?
Solved

Guru! - Need to upgrade SQL Linked Tables Access 07 DB "Not Azure local DB" Office 2013?  Can Office 365 be used?

Posted on 2014-02-24
4
Medium Priority
?
331 Views
Last Modified: 2014-11-12
Hello all,

I have an Access 2007 database that has all linked SQL tables and reports.  I need to convert this I believe first to 2010 then what is the best way to convert this to the later version of Office?   I assume I need to purchase Office 2013 so I can use a local "in-house" SQL database for connecting to?   I don't want to use SQL Azure as I think performance would be degraded.   Then the database has queries using the linked tables and then reports lots of them.   Can this be converted to Access 2013 easily will the reports convert?
0
Comment
Question by:sbornstein2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 82

Accepted Solution

by:
David Johnson, CD, MVP earned 2000 total points
ID: 39884692
The SQL express versions may be all that you need if you want to convert them to sql server database? Otherwise simply open the file then save and publish in the newest format.
0
 

Author Comment

by:sbornstein2
ID: 39886891
test
0
 

Author Comment

by:sbornstein2
ID: 39886902
We have already SQL server and the database.  We also have an access 2007 database with all linked tables to this sql db.   Will Office 365 allow to upgrade this and it would keep all the linked tables in access as is and queries and reports?   i dont want to upgrade the sql db side thats going to run locally in sql 2012 not azure.   i heard maybe a plugin or something
0
 

Author Closing Comment

by:sbornstein2
ID: 39934720
thanks
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Feb. 28, Amazon’s Simple Storage Service (S3) went down after an employee issued the wrong command during a debugging exercise. Among those affected were big names like Netflix, Spotify and Expedia.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question