Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bindueldo
Starting Member
3 Posts |
 Posted - 2008-09-10 : 10:20:27
|
| Hi I have created a linked server to MSAccess 2003 from SQL Server 2000. Actully I am ale to see the mdb file from the server where the SQL server is installed. But when I try to open it from a machine other than the server it gives me the error "Microsoft Jet database engine cannot open the file '\\ampcs04\Test\SamInfo.mdb' , It is already opened exclusively by another user or you need permission to view its data" Everyone has full Control on share Test. I am trying to solve this issue from past couple of days. Please helpthanks |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-10 : 10:39:38
|
| Access is a file DB unlike MS SQL and once its open by a user it cant be open again by another. Only one user can access it at any point in time.also try to see if you have a firewall. |
 |
|
|
bindueldo
Starting Member
3 Posts |
Posted - 2008-09-10 : 11:12:56
|
| No there is no firewall between the access machine and the sql server. Both are on the same network. I am sure that this file isn't opened by anybody else. If I logon to the server (remore desktop ) I am able to see the data , but if I connect to the server from my local EM(added this server as SQL server Group) I am getting the error.thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 12:07:07
|
Are you use same user account when using remote desktop as your local machine?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-10 : 13:08:46
|
| The file might not be open physically, but might be open for read by another user or application. |
|
|
|
bindueldo
Starting Member
3 Posts |
Posted - 2008-09-10 : 13:16:50
|
| Yes I am using the same login to connect to server through remote console.No the file is not been used by any other application. |
|
|
|
|
|
|
Linked Server to Ms Access