2

Can I use Visual Studio Lightswitch togehter with an MS-Access DB? If Yes, makes it sense to use it instead of MS-Access for the developing the GUI?

Elmex
  • 3,331
  • 7
  • 40
  • 64

2 Answers2

3

As far as I know LightSwitch doesn't support using other datasources in the beta but will in the release. So you're out of luck with MS Access for now. Does it make sense... sure if you're more proficient in LightSwitch then MS Access. And LightSwitch has a lot of functionallity to set up your UI faster than MS Access, so I would think so.

RonaldV
  • 633
  • 3
  • 8
  • I dispute the "set up your UI faster than MS Access." It betrays the opinions of someone who likely doesn't know how to use Access, which is very fast for setting up UI. – David-W-Fenton May 28 '11 at 23:03
  • Well trying out both LightSwitch and MS Access I got my UI up faster in the former. Especially how it looks. So maybe it was subjective on my part, but so might yours. – RonaldV May 30 '11 at 10:42
0

Out of the box You can not use access as the data source. The system supports SQL Server, Sharepoint, SQL Server Azure and WCF Ria Services. The SQL Server can be either local or remote.

If you do want to use access I suppose you could use a wrapper around the database file and expose it as a WCF RIA Service, but I would just upsize the database to SQL Server or SQL Server Express.

Mykre
  • 56
  • 3