OK, it becomes a little clearer.
As far as I know, there is no 'Export to Access' ability, although there are so many third-party utilities available, something of that nature might exist. You could build a massive DTS system to export tables, and kludge together some way of getting all the views and procs rebuilt in Access, but I still think that MSDE is the way forward. It is actually a freely-redistributable part of the SQLServer install, and also available as part of MSOffice Dev version. The main advantage is that it uses SQL mdf files, so all you need to do is attach your database, and it will work. Obviously you still need a front-end for it, but you'll need to develop that for any option you take.
There are two secrets to success in this world:
1. Never tell everything you know