>> getting info from sql server

[Jonathan]

Hi, using Access 2003 and SQL 2005. I have a process that uses the sql dmo
object library to determine whether the user has sql admin permission to
continue. In another process I again use the sql dmo library to get a list of
servers and databases attached to each sql server.

The problem is that the sql dmo library is not part of an Access
installation. So, do you have any ideas of how I can acheive these same
outcomes using object libraries that are part of a standard Office/Access
installation?

Any ideas or suggestion appreciated

Many thanks,
Jonathan

 

[Tom van Stiphout]

On Mon, 10 Aug 2009 16:16:01 -0700, Jonathan

If I were in your position my question would be: how do I distribute
SQL DMO library with my application.
I don't know the exact answer to this question, but I would find out
if it is a freely distributable library, and if it is include it in my
Setup program.

-Tom.
Microsoft Access MVP