run a sql-sript from interface

Dear All,

I'm looking for a VBA-code to run a sql-sript from the Access.adp-interface.
I want to send scripts so my client can add sql-server-objects from the
interface.
Thanks,
Filip"Filips Benoit" <benoit.filips@.pandora.be> wrote in message news:<eEGsb.20778$7o6.640107@.phobos.telenet-ops.be>...
> Dear All,
> I'm looking for a VBA-code to run a sql-sript from the Access.adp-interface.
> I want to send scripts so my client can add sql-server-objects from the
> interface.
> Thanks,
> Filip

There are several options - SQLDMO, SQL commands embedded in your
code, reading in and then executing an external file etc. I suggest
you post this to an Access or VBA newsgroup, as you'll probably get a
better response on which is the best approach.

Simon