hi,

i'm learning to use sql server 2000. i've just converted
my access backend database successfully, was able to link
from the front end using access. occasionally i can open
the tables and forms with no problem, but every now and
then i get the following error message "ODBC - - - call
failed, [Microsoft][ODBC SQL DRIVER] communication link
failure (#0)".

what am i doing wrong and how can i fix it?

your response is very much appreciated.

thanx