All tables seem to have disappeared but it still works - Helpplease!!

theintrepidfox

Dear Group

Excuse my ignorance but I have never come across this problem and need
some advice. I have two copies of the same MS Access 2000 database.
One from about 6 months ago ond one recent copy. When I open up the
old copy I can see all tables in the database window. When I open up
the newer copy I just see the three 'Create New Table' options in the
database window.

This happens in Access 2003 on XP and on Vista with Access 2007.
When I connect with MSSQL Server Management Studio to the newer
version and try to import the database, I can see the tables in the
Import Wizard though.

I also still can see all data in Form view just not the tables
themselves.

Any idea why that is? Any help, hint, suggestion is very appreciated.

Thank you for your time and effort,

Martin

Dec 13 '07 #1

Arno R

"theintrepidfox" <th************@hotmail.comschreef in bericht news:af**********************************@e25g2000 prg.googlegroups.com...

Dear Group

Excuse my ignorance but I have never come across this problem and need
some advice. I have two copies of the same MS Access 2000 database.
One from about 6 months ago ond one recent copy. When I open up the
old copy I can see all tables in the database window. When I open up
the newer copy I just see the three 'Create New Table' options in the
database window.

This happens in Access 2003 on XP and on Vista with Access 2007.
When I connect with MSSQL Server Management Studio to the newer
version and try to import the database, I can see the tables in the
Import Wizard though.

I also still can see all data in Form view just not the tables
themselves.

Any idea why that is? Any help, hint, suggestion is very appreciated.

Thank you for your time and effort,

Martin

I have never seen what you describe but ...
Maybe it is the db, maybe it is your Access install or something else...

I would try to import all objects including the tables into a new fresh db.
I hope that the Access-wizard will also see the tables.

Arno R

Dec 13 '07 #2

theintrepidfox

>

I have never seen what you describe but ...
Maybe it is the db, maybe it is your Access install or something else...

I would try to import all objects including the tables into a new fresh db.
I hope that the Access-wizard will also see the tables.

Arno R- Hide quoted text -

- Show quoted text -

Hi Arno

I tried your suggestion of creating a new empty Access database and
importing the data from the one I can't see the tables. As soon as I
select the other database and click 'Import' I get the message 'Record
is deleted'. In the 'Import Objects' window no tables and queries are
listed under the 'Tables' and 'Queries' tabs. The other show content.

Any ideas anyone?

Thanks for your help and effort,

Martin

Dec 13 '07 #3

Fred Zuckerman

"theintrepidfox" <th************@hotmail.comwrote in message
news:af**********************************@e25g2000 prg.googlegroups.com...

>
Dear Group

Excuse my ignorance but I have never come across this problem and need
some advice. I have two copies of the same MS Access 2000 database.
One from about 6 months ago ond one recent copy. When I open up the
old copy I can see all tables in the database window. When I open up
the newer copy I just see the three 'Create New Table' options in the
database window.

This happens in Access 2003 on XP and on Vista with Access 2007.
When I connect with MSSQL Server Management Studio to the newer
version and try to import the database, I can see the tables in the
Import Wizard though.

I also still can see all data in Form view just not the tables
themselves.

Any idea why that is? Any help, hint, suggestion is very appreciated.

Thank you for your time and effort,

Martin

Maybe they're hidden...
Fred Zuckerman

Dec 13 '07 #4

theintrepidfox

>
Maybe they're hidden...
Fred Zuckerman- Hide quoted text -

If they're hiding they better come out because I'm very cross! ;-)

Latest Update:

Attempted a Compact and repair in Access 2003. Never made it to more
than 50% after letting it run for two hours. It's a 37 MB database.
A Compact and Repair with Access 2007 was more fruitful. Can see the
tables now but if I click anywhere on a form I get the 'Record is
deleted!' error a couple of times.

Dec 13 '07 #5