It seems for me that you are using DAO. Wich is not a right way for the network. As soon as your APP is for multi-users over network, I would go with ODBC.