I have an Access 2000 (used as Server) on one computer and about 20 clients (also Access 2000).
clients update (insert, delete, update) their own Access, and then copy their data in Server Access.
the problem is :
one client cannot see the changes made by another one, every one sees only its own changes unless the Server Access is closed and opened.
is there any way to update the Server Access so that all clients see the changes made by others without closing and restarting the Server Access ?