database opened exclusively by another user, or you need permission to view its data
Posted on 2006-06-15
I have a domain xxx.co.uk
On the same server I have a domain sslxxx.co.uk
xxx.co.uk has a database which is working OK on my local pc and remote server.
I want to run some of the files of xxx.co.uk on the sslxxx.co.uk
When the pages from sslxxx.co.uk try to use the database connection I get an error message.
The Microsoft Jet database engine cannot open the file 'D:\home\Default\xxx.co.ukxxx2002.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
It seems I have the connection correct but that permissions may be wrong.
In database properties Security is set to Internet Guest Account (machineName) full control
Can anyone see where I am going wrong please