Error when attempting to open MS Access DB from Server

[Richo1980]

Hi all,

I have successfully been able to write queries pulling information from an Access Database and displaying it in a table on an ASP page....(locally in the

http://wwwroot

dir of my PC)

I have just uploaded the files to an internal server (intranet) where they will reside and am now getting the following error

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file '\\nsyd9004pap\c$\Inetpub\

http://wwwroot\GMS_Stats\gms_st

ats.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

I have checked IIS on the server where this DB resides and have allowed as much rights as I can ... Has anyone seen this error before? I realise it must have something to do with security but I don't know if it's IIS or DB related?

Any help would be appreciated

Thanks