[AccessD] Upsizing to SQL Server

I have a rather large application that I would like to upsize to SQL Server
express.  My concern is that this is a "mission critical" app and am
wondering how to do this.  First, can the express edition be selected from
the Access upsizing wizard?  Second, there are 40 users.  I have no idea
what the actual impact will be on the speed of the app etc.  This would be a
straight data update at first, i.e. just moving the data to the Express
server and linking via odbc (I assume) so that the app works "just like an
access BE".  Since I can't predict the impact, I can't really say whether it
will stand up to the load, be faster, slower, immensely slower etc. and thus
can't just recommend that we "just do it".  SQL Server has a bunch of
improvements that recommend it in general but I have no feel for whether
this would really work.

Has anyone ever done something like this?  The Access BE is approaching 500
mbytes now, with about 40 concurrent users.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/