Home Dashboard Directory Help

MS Access-Datenbankanbindung by Daniel Schunk


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Suggestion
ID: 683037
Opened: 8/4/2011 11:43:18 AM
Access Restriction: Public


Liebes VSLS-Team,

auf den ehemaligen Beta-Webseiten zu Visual Studio LightSwitch wurde die Konnektivität mit Microsoft Access in der Post-Beta-Version angekündigt; in der finalen Testversion von VSLS 2011 finde ich aber keine Möglichkeit, mdb- oder accdb-Datenbanken anzubinden.

Daher meine große Bitte: Unbedingt Access-Datenanbindung realisieren und bereitstellen!

Viele Grüße aus Hannover,
D. Schunk
Sign in to post a comment.
Posted by Brad Stevens on 1/23/2013 at 9:06 AM
Not feasible to migrate Access to SQL in a lot of situations where LightSwitch would be useful (where either local SQL Server is not possible, or subscribing SQL Azure overkill) and provides a significant barrier for Access developers looking to move to LightSwitch (who may then prove a business caser for SQL Server after the fact).

Please reconsider removing this barrier.

Brad Stevens
Posted by Microsoft on 9/7/2011 at 11:32 AM
Attach to Access isn't directly supported by LightSwitch. Our recommendation is to use the SQL Server Migration Assistant (http://blogs.msdn.com/b/ssma/) to migrate your Access database to SQL Server or SQL Azure, and then have LightSwitch connect to the SQL db. This blog article (http://blogs.msdn.com/b/zaneadam/archive/2010/08/12/moving-to-the-sql-azure-cloud-from-access-or-mysql.aspx) contains some more information with links.

Thanks for the feedback.
Sign in to post a workaround.