Refreshing Views List

L

Luis Faceora

Hello!

In my adp, I have a VBA function where I need to create a view dynamically
and then open it.
But meanwhile I need to refresh the views list somehow, otherwise it will
bring up an error opening the view.
I don't have the database window open, so I believe the
RefreshDatabaseWindow is out of question.

Currently, i make the project reconnect to refresh the views list but that
clearly isn't the best solution.

Anyone knows how to do this?

Thankyou in advance for your time,
Luis Faceira
 
R

Robert Morley

It's not an ideal solution, but you can always unhide the database window,
refresh it, then re-hide it. If you find any other ways, let me know, as I
have a similar issue that I'm working around.


Rob
 

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

Similar Threads

SPs vs. Views 2
refreshing project in code 2
How to refresh (programmatically) an ADP project's knowledge about views and stored procedures? 16
Refreshing database window 5
Drop and re-recreate views 4
ADP - Report Recordsource Permission Error - View ... Does Not Exist 6
refreshing tables with code 1
Database Form security 3

Top