Hi all ,
I've this problem : I need to extract the SQL source of some view from SQL
SERVER's database, to make that I'll use:
http://databases.about.com/b/2007/11...ext-in-vba.htm

that's works great in mdb file but my project is adp !! , how can I
reference a Database object(DAO) in adp? is it possible ?
thanks in advance
Regards

No, you can't use that approach in an adp. You didn't give the SQL Server
version, but check books online to see how to query the system for that
info. In SQL 2005 for example there is a system view named
INFORMATION_SCHEMA.VIEWS that has a view_definition column. Note that it
will be null if the view definition exceeds 4000 characters. There are other
system tables if you're using a different version.

The closest thing to currentdb in an adp is currentproject, but it's not the
same object since you're not dealing with any Access storage.

"TheBest51" <(E-Mail Removed)> wrote in message
news:6409C00C-13DF-435C-A1A2-(E-Mail Removed)...
> Hi all ,
> I've this problem : I need to extract the SQL source of some view from SQL
> SERVER's database, to make that I'll use:
> http://databases.about.com/b/2007/11...ext-in-vba.htm
>
> that's works great in mdb file but my project is adp !! , how can I
> reference a Database object(DAO) in adp? is it possible ?
> thanks in advance
> Regards

Thanks Thanks a lot !!! your Reply has been very useful and helpful !!!
Thanks

"Paul Shapiro" wrote:

> No, you can't use that approach in an adp. You didn't give the SQL Server
> version, but check books online to see how to query the system for that
> info. In SQL 2005 for example there is a system view named
> INFORMATION_SCHEMA.VIEWS that has a view_definition column. Note that it
> will be null if the view definition exceeds 4000 characters. There are other
> system tables if you're using a different version.
>
> The closest thing to currentdb in an adp is currentproject, but it's not the
> same object since you're not dealing with any Access storage.
>
> "TheBest51" <(E-Mail Removed)> wrote in message
> news:6409C00C-13DF-435C-A1A2-(E-Mail Removed)...
> > Hi all ,
> > I've this problem : I need to extract the SQL source of some view from SQL
> > SERVER's database, to make that I'll use:
> > http://databases.about.com/b/2007/11...ext-in-vba.htm
> >
> > that's works great in mdb file but my project is adp !! , how can I
> > reference a Database object(DAO) in adp? is it possible ?
> > thanks in advance
> > Regards
>
>

"TheBest51" <(E-Mail Removed)> ???????????????? news:6409C00C-13DF-435C-A1A2-(E-Mail Removed)...
> Hi all ,
> I've this problem : I need to extract the SQL source of some view from SQL
> SERVER's database, to make that I'll use:
> http://databases.about.com/b/2007/11...ext-in-vba.htm
>
> that's works great in mdb file but my project is adp !! , how can I
> reference a Database object(DAO) in adp? is it possible ?
> thanks in advance
> Regards