Trying to add data connection but sql doesn't like me tonight

[tonyonlinux]

For some reason I can't add my dataconnect. I click on add connection select sql server then I browse to the programfiles/...sqlserver/data and click on books.mdf it tells me every single time that the file is in use. But I don't know of any program that would be using it. I'm running the server on my desktop simply to try and learn it and do a little programming with it. i can't seem to understand why it will not access that database. Any help would be great thanks...

[WoutL]

With ProcMon[^] you can investigate which process has the file in use.

Wout Louwers

[Mycroft Holmes]

At a guess the database has a connection that is still live, it may be left over from debugging or a corrupt connection. Also Access may be corrupt and refusing the connection, try repair and rebuild via the Access UI.

Never underestimate the power of human stupidity RAH

[Roger Wright]

Is there a new file in the directory holding your database, specifically a lock file? I'm new to SQL Server, but in Access a file is created when a connection is established that locks out other users. Sometimes when connections are not correctly closed, the file defining the lock is not deleted, blocking any subsequent access attempts. Deleting the locking file eliminates the problem. Is there an equivalent locking file in SQL Server? If so, deleting it may restore your access to the database.

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

[tonyonlinux]

I finally got it resolved. I actually had the server manager running connected to the sql server. So I took and closed that and refreshed the datasource and worked fine. thanks for the help all