Hi,

Can you post the code that you're using to connect to the database? It could
be a number of things. If you're using windows authentication to connect it
could be that some users don't have sufficient rights to write etc.

Otherwise I'd look at locking

Sam


"Lina" wrote:

Hi,
Has anyone had any random problems when trying to connect to a database
from excel?

I have just taken over the administration of an excel vba application that
reads and writes to a database.
It has worked ok until now but now many users sometimes have problems when
saving data. The problem for me is that I can not get the same error. It
happens for some users sometimes and I can not make any sense of it. I think
that the application stops when connectiong to the database. I wonder if this
can have anyting to do with other settings on the users computer. Can it be a
new office update, bad internet connection, to many people working with the
database at the same time or something else?
They use excel 2003 sp2 and sqlserver 2005 (I think it's sp 2)

Thanks