How to refresh database objects?

[Guest]

Hi,

I'm confused with the following problem. I have a database in which I let
some procedures run during evenings and nights so that they would be ready in
the morning when I'm back at the office. Now, it happens sometimes that the
procedures stop running because there can't be found any tables in the
database. Also when I look at the database window I can't see any tables or
queries. How is that possible? Forms and modules are still visible. If I
close the database file and open it again the tables and forms are again
visible. Can I somehow "refresh" the contents of the database so that the
procedure woudn't stop running? Does this have anything to do with the fact
that the database file is not on my PC but on a company server...? Many
thanks in advance. -Marko Utriainen-

 

[David Lloyd]

Marko:

I have run into this issue in the past. I was able to use the
RefreshDatabaseWindow method of the Application object to refresh the
database window to reflect changes.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


message Hi,

I'm confused with the following problem. I have a database in which I let
some procedures run during evenings and nights so that they would be ready
in
the morning when I'm back at the office. Now, it happens sometimes that the
procedures stop running because there can't be found any tables in the
database. Also when I look at the database window I can't see any tables or
queries. How is that possible? Forms and modules are still visible. If I
close the database file and open it again the tables and forms are again
visible. Can I somehow "refresh" the contents of the database so that the
procedure woudn't stop running? Does this have anything to do with the fact
that the database file is not on my PC but on a company server...? Many
thanks in advance. -Marko Utriainen-