I am working with a potential client where the original developer moved out of town and now the client needs his application to evolve. The problem is there is no documentation on the application at all. The front-end of the application is MS Access based and the backend is SQL Server 2000 based. What I would like to do is get a copy of the SQL Server data files and install them on my copy of MDSE and then install the front end on my PC as well and create the ODBC links to the data tables. I am new to SQL Server and I am wondering what is the best way to transfer the tables and relationships setup in SQL Server on the potential client's server to my PC in my office?

Thanks in advance!:)

If I am not mistaken, the files will reside in a .mdf file.

Thanks Ken:)