Very Computer

I developped an application using VB 6 pro, it works
perfectly, however, I installed the software on 3
computers (one server and two workstations).  When the
software is on a workstation, it should connect to an ODBC
database(Access) located on the server.  All permissions
on the server are set correctly, as far as I can see.  The
software connects correctly to the database on one of the
workstations, but not from the other..  I do not get
errors opening the database, I get errors, it seems, after
opening the database and doing queries within Access.  
Again, it works on one workstation, but not the other.  
Any ideas, or do you need more info?  Please contact me
soon with suggestions.  Thank you.