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 |
|
Carlos Marques
Starting Member
1 Post |
 Posted - 2007-07-03 : 04:04:27
|
| Hi,I have a msaccess linked server that I use to execute sql 2000 stored procedures from a front end in adp (access data project) format without any problem, whatever user is logged on since it is used on the same machine where the sql server resides . In any other machine on the local network where I also need to use it, I get an ole/db error message saying that the microsoft jet database engine can not open the file because it's allready opened exclusively or because it do not has permissions. All the users are using the Windows NT security and have permissions to the network drive where the mdb is stored. The mdb doesn't have any security.I created the linked server with both UNC and normal path with the same result. I also tried with sp_addlinkedsrvlogin for the users in question with no results.Thank's for all the help/clues you can give me.Charles |
|
|
|
|
|
Connect msaccess ole/db linked server