Manipulating SQL Server 2008 Objects in VBA via SQLDMO/SMO

[snakehips2000]

I use Access 2003. For many years I was able to dynamically manipulate the structure of objects in my network SQL Server 2000/2005 databases (i.e. tables, views, stored procedures etc.) by creating a reference to the SQL Server DMO object library (Tools, References).

The network SQL Server instance I'm using has now been upgraded to 2008 and when I attempt to write VBA code to do the same actions as I did previously, I get a message telling me that SQL-DMO is not available in SQL Server 2008 and that I must use SMO (SQL Server Management Objects) instead. How is this done? There is no reference to such an object library in the list displayed within "Tools, References".

I know someone will probably say upgrading to Access 2010 is a possible solution. However, that is not an option for the application on which I'm working as there numerous users, all of whom are still happily using Access 2003.

Thanks.

 

[UnsolvedCoding]

Would Microsoft SQLDMO Object Library work for you?

It should be in your references.

 

[snakehips2000]

No, that's the same object library I mentioned in the initial post. The point being that it doesn't work for SQL Server 2008 and has been "replaced" in some way by SMO. How to make some alien contact with the elusive SMO is what I seek.