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
305 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
  • 3
4 Comments
 
LVL 78

Accepted Solution

by:
David Johnson, CD, MVP earned 500 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Synchronize a new Active Directory domain with an existing Office 365 tenant
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
how to add IIS SMTP to handle application/Scanner relays into office 365.

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now