Re: Missing Objects in Database window
- From: Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 20 Nov 2005 03:15:00 GMT
Patty O Dors wrote:
"Emily8" wrote:
I have an access database that has a number of tables, queries and reports. When my user went in yesterday, everything was gone. I restored the file from back up, but there is still nothing listed.
Is there a hide objects command that would hide all the objects from the user's view? Unless someone else went in and deleted all the tables, queries and reports (hundreds), I can't think of any other solution.
Any insight would be appreciated.
Yes, there is; you can try opening Tools --> Options, and on the "View" Tab, click the "Hidden objects" check box.
But I can't see much value in hiding every single object in the database. I usually hide the objects that I don't expect to need to edit often. If they were indeed all marked as hidden objects, then having rendered them visible, you might want to change their properties to de-hide them. With "hundreds" of such objects, a VBA function in a Module might be the easiest way to proceed, if you're comfortable with using VBA.
If the problem is not one involving the "hidden" attribute, you might need to open a new, empty database, and import the objects into it. This will likely be tedious, so try doing something else first.
-- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx> Please feel free to quote anything I say here. .
- Prev by Date: Re: Graphing issues
- Next by Date: A tough problem for me to crack
- Previous by thread: Re: Access reports
- Next by thread: A tough problem for me to crack
- Index(es):
Relevant Pages
|
