Vanishing Tabledefs

H

Hoof Hearted

I've been developing Access Applications for 11 years now but i've never seen
this...

I have a workstation running an access database located on a network server.
I have six tables within the .MDB, 6 tabledefs attached to a backend database
on the server, and 10 tabledefs pointing to a SQL Server database.

Part way through executing some code, I get a 'Disk or network Error'
message at a point when my code opens an attached table. At this point, every
one of the tabledefs has vanished from the database window. If I close the
database and reopen it (without exiting MsAccess), all the tabledefs reappear.

Anyone got any ideas?
 
H

Hoof Hearted

Thought I should just mention that when the Tabledefs are visible, I can open
the tables and browse the data without any problems. This couldwell turn out
to be a network problem, but i've never seen one manifest itself like this.
 
Top