'Invisible' Table ??

  • Thread starter Thread starter John Milward
  • Start date Start date
J

John Milward

Hi folks
Your help with this would be appreciated......
I seem to have "Lost" a table allthough I still have the data visible
through a linked table.

I have an Access2000 database which pulls together information from, the
Company business system (SQL based) and other tables that I have created in
Access.

One of these is a table of equipment kept in an Access database called
"Instruments" on a mapped network drive.
The Main Access Database links to this and shows all the records I expect to
see and is correctly linked to the above database

HOWEVER
When I look in the "Instruments" I can't find a table with this information
in it. There is a query there, which is supposed to have a table called
Instruments as its source but no such table exists. The query shows all the
data though!

I suspect I have moved the source table somewhere and Access has kept track
of it. But how do I find out where?
Or is there some other possibility

TIA

John
 
Back
Top