Solved

Access 2013 SQL backend?

Posted on 2015-02-06
6
299 Views
Last Modified: 2015-02-07
Hi

I don't have MS Office 2013 and was told that it now has a SQL backend and has moved away from the 2010 and previous versions' format. Is this true? Can the database be split and the SQL backend be used as a normal SQL database?
0
Comment
Question by:murbro
6 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 250 total points
ID: 40595362
I always wonder who tells such stories.

Nothing has changed in this regard since Access 2007. You can have backends of accdb, mdb (Jet version 4), SQL Server, or any other database engine you can attach via ODBC or ADO.

/gustav
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 40595483
I use 2013 in my day-to-day work, and as gustav said nothing has changed, other than web apps. Web apps always have a SQL back end, so perhaps that's what you've been reading.
0
 

Author Closing Comment

by:murbro
ID: 40595494
Thanks for setting that straight!
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 57
ID: 40595592
yes, that's true, but as Scott was suggesting, they were talking about web apps.

  Access has split into two almost separate products:

1. The old "desktop" style apps - In regards to these, nothing has changed in regards to using SQL as a backend.   A2013 however did depreciate a number of features, one of which was ADP's (native interface to SQL).  That doesn't mean you still can 't use SQL as a backend via ODBC and linked tables or OLEDB/ADO (note however that Microsoft is moving away from OLEDB - ADO does have ODBC providers though, so you'll still be able to use ADO even so if you want).

2. Web Databases/Apps - This is what you heard about.

  Web Databases were found in A2007/2010 and used SharePoint lists to store data, which did not work well and was limited.  More than 5000 or so records and you would start to see performance problems.

 With A2013, web databases were discarded and you now have web apps, which still run through SharePoint, which is where the "front end" executes, but the data is now in a SQL backend.   Thus they are highly scalable.

  A2013 itself is only used for the development of the app.  Once developed, you package it up and deploy to SharePoint.

 I would also add that at this point, development of Access on the desktop side by Microsoft is pretty much dead and has been since A2007.   Their entire focus is the web side of things.

 So what you've got to work with is what you've got.  Don't expect any new features on the desktop side of things.

HTH,
Jim.
0
 
LVL 75
ID: 40595859
Actually .,. I'm pretty sure murbro was asking or thinking about what Jim posted ... Access Web Apps that automatically get a SQL Server back end.

Just sayin' ...

mx
0
 
LVL 57
ID: 40595898
I was trying to clarify a bit ...nothing need be done.

 Anyone reading this will walk away with the right info.

Jim.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sort Time by AM and PM in query 2 21
Run Time Error 3071 26 41
Is it possible to reset DSum? 12 44
field number type in access tabledefs fields 5 20
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

863 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

21 Experts available now in Live!

Get 1:1 Help Now