CurrentDb() in adp file


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question