Database backup from ADP application

if it is possible, how would i go about creating routines (storedprocedures?
)
that can be invoked from a microsoft access ADP file that will backup (and
hopefully have the ability to also restore) as SQL Server database?
thanks for any and all help!
benYou would execute the TSQL BACKUP and RESTORE command from your Access appli
cation. As for how you
execute TSQL command from Access, I suggest you ask in the Access group(s).
:-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ben" <ben_1_ AT hotmail DOT com> wrote in message
news:3AC37D13-C777-462C-ABFD-13F82698A070@.microsoft.com...
> if it is possible, how would i go about creating routines (storedprocedure
s?)
> that can be invoked from a microsoft access ADP file that will backup (and
> hopefully have the ability to also restore) as SQL Server database?
> thanks for any and all help!
> ben