Backup SQL Database

The menu item "Backup SQL Database" does not appear as a
choice under Database Utilities when running an Access
2003 Project connected to an MSDE 2000 database on the
local machine. Why?
hi,
JBMoore wrote:
> The menu item "Backup SQL Database" does not appear as a
> choice under Database Utilities when running an Access
> 2003 Project connected to an MSDE 2000 database on the
> local machine. Why?
I've no particulary skill with Access, but the menu item is available to me
even when connected to a particular database with "public" role membership
only, as I thought that under circumstances of being member of
db_backupoperator database role at least was the reason of the menu item not
being shown... but is not the case.. ok the backup failed for insufficient
privileges :D:D
perhaps you've better post the question on Office NG...
sorry
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql