I know it's been a year since you posted this, but I am starting the same 
type of project and THANK YOU.  I couldn't find this kind of data 
anywhere!!

However I do have a few questions...

"depending on what your app does, they may have to have the Access/SQL 
compatibility update installed, too."

If my app does what specifically?  
 
"Second . . . and a better solution I think.  If you are going to use the 
SQL Server 2000 version of MSDE, then use Access XP as your front end."

We do plan on upgrading to XP eventualy.  Is there any problems I should 
be aware of if I am upgrading an existing Access 2000 project to XP 
version?

Thank you once again!!  And if anyone else is reading this, I'd appreciate 
their input too.