Missing Database Objects - Access 2010 Forms, Queries, Tables, Reports

[naz123]

Hi all, so im trying to make some changes to one of my databases but i cant see any of the objects, i.e. the Tables, Queries, Forms, Reports etc...

They just dont show up in the Navigation Pane, i haven't changed any settings to hide them.

Can anyone help on how i can retrieve these?

The database still works fine so everything is there just cant see it.

[ranman256]

The database may be hidden.
there's a setting you can run.....
like...database.hide= false.
i use it in a macro. (I can't access my PC from here)

also try right click on the db, see if its there.

[naz123]

Hi, thanks for replying.. i'm sorry i'm not sure what you mean..

how can i run that setting?
&
where do i click?

[John_G]

Since the database still runs fine, that suggests to me that the startup form or macro is doing something to make the objects invisible. If you have a startup form selected, change the setting to no form, close and reopen the database. (holding down the shift key while opening the database should do the same thing.)

[naz123]

Tried changing to No Form, and opening the database by holding down shift key.. .the objects are still hidden :|

[John_G]

Try creating a new, blank database, and then import all the objects from the old database into it. See if it works before making any other changes.

[naz123]

Hi John_G thanks for that i am now able to view my missing database objects..

Whilst testing it all does not seem to work, it crashes out on this piece of code.. any idea to why this may not work?

Dim Db As Database, rs As Recordset, chek As String

[John_G]

I don't see anything wrong in that line - what is the error message? My guess would be that there are some missing references. I should have mentioned that - when you import all the objects into a new database, the references are not copied with them.

To see the list of references, open any code module, then from the menu select Tools - References.

Not sure if this will work, but you might be able to see the references in the old database by opening the immediate pane (Ctrl-G), and doing Tools - References from there.

[naz123]

this is where it seems to be crashing out, with the following error message..

i have checked the references the same are ticked on the old version as they are on this new one.

[John_G]

OK. What you can now try is to move the reference to Microsoft DAO.. reference up in the list as far as it will go. Select it, then use the priority up-arrow. Then re-compile. This has worked for me many times when I get strange errors like that.

If that one doesn't work, try the Microsoft Office xx Onject Library

I have just noticed something - is your database file named database.mdb (or accdb)? If so, try renaming it. "Database" is a microsoft reserved word, and I think that is confusing Access. Notice that the error message show that Access thinks you have reference the project called "Database".