Database

ghumman63 wrote:

only my service is accessing this db ,, not any ohter application

ghumman63 wrote:

""The Microsoft Jet database engine cannot open the file '\\software-11\Access\terminaldata.mdb'. It is already opened exclusively by another user, or you need permission to view its data. 12/14/2006 12:38:50 PM
""
i m getting this error when i access mdb file from my window service,,
i have accesss to that file ,, but in my service i get this exfeption

can any body help me ,, thanks in advance

print getdate()
GO

use master

declare @dbName nvarchar(1024)
SELECT @dbName = 'dbname'

declare @rowCount int
declare @spid int

SELECT @rowCount = 1

while (@rowCount > 0)
BEGIN
	create table #temp
	(
		spid int,
		ecid int,
		status varchar(256),
		loginname varchar(256),
		hostname varchar(256),
		blk int,
		dbname varchar(256),
		cmd varchar(256),
		request_id int,
		id int identity
	)

	insert into #temp
	exec sp_who

	SELECT TOP 1 * FROM #temp WHERE dbname = @dbName 

	SELECT top 1 @spid = spid
	FROM #temp
	WHERE dbname = @dbName 

	SELECT @rowCount = @@rowcount

	if (@rowCount > 0)
		exec('kill ' + @spid )

	drop table #temp
END


RESTORE DATABASE [MedinaGold] 
FROM  DISK = N'backupFileLocation' 
WITH  FILE = 1,  
	MOVE N'data_name' TO N'c:\data\2005\cs\_Data.mdf',  
	MOVE N'log_name' TO N'c:\data\2005\cs\_Log.ldf',  
	NOUNLOAD,  REPLACE,  STATS = 10
GO