- 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
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
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