MSDE is the free version of the SQL-Server. They are both using .mdb and
..ldf for their database files and you can detach a database from SQL-Server,
copy the .mdb and .ldf files and reconnect them directly to MSDE; at the
condition that the size of the database is under 2Gigs.
Instead of detaching/copying/reattaching the database, you could also make a
backup/restore process.
However, you will have one problem with MSDE: it doesn't have a graphical
interface so you must use a command line utility such as osql or you must
install the graphical interface (also called the Enterprise Manager or the
client tools) of SQL-Server on your machine.
If you don't have a commercial version of SQL-Server, then you can buy the
developer version of SQL-Server 2000 (around 50$) or try with the SQL Server
Management Studio Express; which is for SQL-Server 2005 Express but should
work equally well with MSDE or SQL-Server 2000:
http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
If you have questions, then you can post in the m.p.sqlserver.msde
newsgroup. There is also a newsgroup for ADP: m.p.access.sqlserver.adp .
Now for your reports under ISA2004: I absolutely don't know anything about
them. MSDE is a database and doesn't have any integrated reporting
functions. SQL-Server 2005 has something about that but it's not a standard
installed component of ISA2004.
