Which SQL Server To Use For Access Applications

[vdanelia]

Hello Dear friends, I have a question about connecting Access Database to SQL Server.
For security reasons I want to store my access flat file data to SQL server... Which version to use, I think that I needn't the enterprise or r2 versions... I just need it only for access databases (about 15-20 user will work simultaneously)
Which SQL Server do you recommend for this purpose?

Thank you very much in advanced

 

[boblarson]

I recommend SQL Server 2008 R2 Express. It stores 10 Gb of data and will work with many users. But it really does depend on which version of Access you are using. If you are using anything earlier than 2003, my suggestion would change.

 

[bparkinson]

You are right, you don't need Enterprise edition. I put my customers on Standard edition. I need SSIS packages to be scheduled to run on their own and also want backups to run unattended. Standard edition is relatively cheap.

 

[Galaxiom]

If using one of the paid versions of SQL Server don't forget to buy the Client Access Licences too.

 

[vdanelia]

Hello Dear Friends for the reply:
My Access Database Is based (Built) On Access 2010
As I know MS is developing free for use MSSQL "Express" I think..