>Hi everybody,
>
>I have a database on the test server. I also used to have a database on the local PC, but not anymore (though I found some MDB file).
>
>My question is - what would be the simplest way to copy the database from the test server to the local PC and how would I adjust the connection string to use it locally?
>
>Thanks a lot in advance.

Easiest way is to detach it from test server, copy it to local one and attack it to both.
Other way. Make a backup of the DB on the test server. Create and empty database with the same name on your local server, then restore that Backup with overwrite database.