Hi

I had a previous question and I have to clarify. I am using an Access 2002
Project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server
Espress).

I was wondering if anyone new if it was possible to restore a Database that
was Backed up by SQL Server 2000 developer edition, into an Access 2002
Project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server
Espress). I have been told that it was possible and one of the responses I
got
was:

'What you need to do is specify a new file location for the .mdf and .ldf
files during restore using the WITH MOVE syntax.'

During the retore process in an access Project, there is no configuration
for this syntax (unless you can do it by VBA??).

I had no problem doing this when I restored using the demo version of SQL
SERVER 2005 (It gave me no errors) , but the same process does not work in
Access 2002 project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL
Server Espress).

Any Ideas?

Thanks

Frank Srebot

Frank Srebot wrote:
You restore the SQL2K database backup to the MSDE database. You need to use the WITH MOVE clause because the file
locations of the SQL2K database are probably different from the locations of the MSDE database. The links from Access
to the MSDE instance don't change.

Or am I missing something?