I have recently had to perform the same task & as a word of wisdom ( or rather bad experience ) bewaware of any server side & client DSN/ODBC drivers...

Hi Junie01,

Tried your response before, i.e restored db, detached db, renamed the physical files on disk, attached db, but to no avail. It did not change the logical filename,...

Allen,

You are a scholar & a gentleman !

In other words, thanks, it worked a treat.

Regards.

j