Nevermind... I figured it out. For more info see: http://www.1planhost.com/support/s_sql2000cnu.asp

From there it is a simple matter of registering the db in Sql Server.

Thanks for getting me going...!

In the ODBC setup what do I put in when I get to the "What SQL Server do you want to connect to?" Do I specify the IP address or...

I want the user to be able to view the tables, run queries, etc. directly from the database but on his machine...

Excellent.. thank you very much.

I tried backing up and restoring. But for some reason it would not let me restore to a different folder/structure. It insisted that I replicate the folder structure (which I...

Oleg,

I do have access to the server and can shut it down. What are the specific steps in doing what you suggest?

Once I detach db what files do I copy?

...