help! all of a sudden can't connect to my db

hello,
i've been running fine with the same msft sql server set up for over a year
now. each night i run some vba code which connects with the db and does some
data updates. all of a sudden i'm having trouble communicating with the db.
when i attempt to connect to the db via query analyzer, i get the message:
Server: Msg 924, Level 14, State 1, Line 1
Database 'artorius' is already open and can only have one user at a time.
what the dillyo? maybe some setting got changed? how can i change it back?
hopefully this is not a symptom of a larger problem. anyway, would
appreciate any suggestions to get this working again.
appreciated,
matthew
nevermind, i switched the setting back. sorry for the panic. i have no idea
how the setting got switched in the first place though.
"matthew c. harad" wrote:

> hello,
> i've been running fine with the same msft sql server set up for over a year
> now. each night i run some vba code which connects with the db and does some
> data updates. all of a sudden i'm having trouble communicating with the db.
> when i attempt to connect to the db via query analyzer, i get the message:
> Server: Msg 924, Level 14, State 1, Line 1
> Database 'artorius' is already open and can only have one user at a time.
> what the dillyo? maybe some setting got changed? how can i change it back?
> hopefully this is not a symptom of a larger problem. anyway, would
> appreciate any suggestions to get this working again.
> appreciated,
> matthew