Use SQL Server Express engine in MS Access

95 views Asked by At
  • Is it possible to use SQL Server Express engine with MS Access?

The reason, why I am asking is, that I want to get rid of Jet/ACE engine and the limitation of 2GB per db file.

Thank you for your feedback,

Cralevic

1

There are 1 answers

0
Vojtěch Dohnal On BEST ANSWER

Definitely Yes, but adp projects are unfortunatelly not supported in Access 2013 and higher. You can use linked tables. But it would be better to migrate e.g. .NET WPF or WinForms project when using SQL database as a backend. See http://www.dummies.com/how-to/content/finding-alternatives-to-access-data-projects.html