Access database versions and SQL backend

Hi
In Access if I want to use cloud SQL tables as the backend is there a specific type of database that I should
create and does the version between 2007 and 2016 make a difference? If there is a difference can I develop in 2007 and
later convert to 2016?
Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There's no specific type of database you need to use, but be aware that using cloud-based databases can result is very limited performance. Many use the Azure platform, which is essentially a cloud-hosted Microsoft-hosted SQL Server. You pay a monthly fee (around $5.00, if I recall) for a 1gb database, and you don't have to worry with setting up, licensing, and managing a SQL Server. Here's more information on doing that:

http://www.fmsinc.com/microsoftaccess/cloud/link-to-azure-sql-database.html

Also note that you should create your FE as close to a true "client" as possible. For example, you should always filter data coming back from the server to retrieve the smallest dataset possible - no more basing your forms on a Table.

It makes no difference as to the Access version, and in general you can convert your 2007 database to 2016.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.