Backup and restore

[Mark]

Hi

Using Access XP on msde SQL 2000, I have created un .ADE program.

Now, with the .ADE program I can do the backup of the database located on
the msde on the same computer, but
I am not able to restore the database.

Backup command : DoCmd.RunCommand acCmdBackup

Restore command : DoCmd.RunCommand acCmdRestore ----> but it
does not work

Someone can help me? Is it possible?

Many Thanks in advance

Marco Dell'Oca
D.M.Software

[Mary Chipman]

If you look up the Restore command in Access help, you will see that
it is about restoring a window, not a database. You can backup and
restore databases easily using the Enterprise Manager if you have the
full version of SQL Server. If you don't, you can programmatically
backup and restore using SQL-DMO, which is documented in SQL Books
Online. There's no way to do this from a macro.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

[Guy Horton]

Hi Mark,

If I understand the question correctly you want to be able to backup and
restore your MSDE database.

Access 2002 does provide database backup and restore commands under the
tools/database utilities menu which you could access via a customised menu
or toolbar?

Hope this helps
Guy

"Mark" <dmsof...@tin.it> wrote in message
news:XC4a9.16019$pX1.4...@news2.tin.it...

[Mark]

Thank Mary

I have solved the problem.

Marco Dell'Oca
D.M.Software

"Mary Chipman" <mc...@nomail.please> ha scritto nel messaggio
news:2grhmucqot2unf2ui...@4ax.com...

[Mark]

Thank Guy

I have solved the problem.

Marco Dell'Oca
D.M.Software

"Guy Horton" <guy.h...@microscienta.com> ha scritto nel messaggio
news:#npvLDXTCHA.1952@tkmsftngp09...