SQL-DMO

[Guest]

I'm new to Access. I am trying to download a template from microsoft and I
get an error saying "SQL-DMO must be installed on the machine...." I've
tried various things to fix it, but obviously don't have a clue. Any help
would be greatly appreciated, thanks in advance

 

[Norman Yuan]

SQL-DMO is an object library used for SQL Server management, which gets
installed as part of SQL Server installation. Obviously, the "template" you
are downloading contains some functionalities of SQL Server management. So,
you have to install a version of SQL Server (all or only its client tools,
not sure) first.

 

[Guest]

I installed SQL 2005, is there a setting that needs to be changed in SQL or
Access?

thanks,

 

[Norman Yuan]

If you have installed SQL Server2005, you should have SQL Server DMO library
installed. Open the Access application, go to VBA IDE, click menu
"Tools->References...", in the dilaog box, you should be able to find an
item "Microsoft SQLDMO Object Library". Check the preceding check box and OK
dialog. This should fix the problem with the Access "template".

However, if your Access app built on this template will be used with future
SQL Server (2008 and later), then, you should not use DMO, 'cause it will be
dropped from SQL Server2008. MS recommends to use SMO (.NET version of
replacement for DMO) to do SQL Server management.

 

[Guest]

Is there a way to check "Microsoft SQLDMO Object Library" before downloading
the template as a default setting for all databases? It fails to finish
downloading the template, which means I cannot change this setting for this
particular database.