Hi

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. 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.

Any Ideas?

Thanks

Frank Srebot

Hello Frank,

You cannot restore SQL Server into Access, regardless of versions. I am not
aware of any downside options either. People normally wish to migrate the
other way, or if you want SQL on the desktop you would use one of the normal
SQL SKUs or even SQL Express.

The WITH MOVE syntax is for moving the location of data and log files, when
restoring to another SQL Server. There is no support for Access in this way.

Hi Frank,

Why are you trying to restore a SQLServer DB to Access 2002? Bit like
turning a Ferrari into Mini (no offence to Mini owners ).

Anyway, why dont you set up a DTS package copy updated data to your target
Access database for a start. Or try replication , although I dont know if
replication to Access would work.

But if I were you I would write a DTS package to push your Db data to your
Access db.

Other than that,, you cannot restore a SQL db to Access using Restore backup.

cheers

Paul

"Frank Srebot" wrote: