Table And Query disapearing? (1 Viewer)

[DemonHub]

I have a shared database on a network and sometime the table and the query disapear and we have to close the application and restart it to solve the problem each time.

It's only happening to 1 user each time it's happening , but not always to the same user.

the tables and querys are still there but the application thinks there nothing and can't perform SQL and when we open any form we see #Name in each fields.

We dont lose data but it's really annoying.

If you have any clue don't hesitate to tell it.

Thanks

 

[llkhoutx]

To me, it aounds like the table is opened exclusively by another user.

 

[DemonHub]

It's not only on 1 table it's on all the tables and it's only happening on 1 user at a time.

It's look like someone have deleted the tables and when the user restart the application all the tables are there again and working.

 

[Bat17]

if it is happening to all linked tables at the same time then it is most likley a network issue. If Access losses a beat talking across the network it will not reconect the tables automaticaly when the network come back again.

Peter

 

[steevie_t]

Sounds like a slightly corrupted file. Back it up, back it up again, and then do a Compact/Repair.

You don't say how the database is shared, is it a Split database with Linked tables, or do all the users open the same file.