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
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