MS Access-Datenbankanbindung by Daniel Schunk

Closed

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

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

Workaround(s)

view

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

Details (expand)

0 attachments

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.

Microsoft