CurrentDb() in adp file

[TheBest51]

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/13/accessing-sql-query-text-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

 

[Paul Shapiro]

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]

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

 

[11122]

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/13/accessing-sql-query-text-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