SQL Server Express Backend - Access Forms Front end

[Jorge via AccessMonster.com]

I've done a little research on the SQL Server Express. Do you know if I will
have any problems or limitations using SQL Server Express as the backend
database tables and using MS Access as the front end? all on the network.

This will have 75+ concurrent users nationwide that will use the network from
their laptops to access the database.

Please, your thoughts and advice...

Thanks,
Jorge

 

[Sylvain Lafontaine]

It will works but users won't scream because the system is too fast. This
is more a problem about Access and the network than about SQL-Server
Express.

Excerpt for the most simple cases, the usual solution for going over the WAN
(instead of a local LAN) is to use Terminal Server (TS) or anything else
than Access with ODBC linked tables. If you know how to do it, using ADP or
passthrough queries will give you a much better performance than linked
tables but the best in my opinion would be to use either TS, ASP.NET or .NET
Winforms.

Finally, if you are not using ADP, this is not the right newsgroup for this
question.