Linked Servers - Real Post
From: Gerard (anonymous_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: freakazoid: "Re: sp_column 2-tables insert matching columns"
- Previous message: Aaron [SQL Server MVP]: "Re: Setting execute permission on stored procs is inconsistent"
- Next in thread: Mike Perry: "Re: Linked Servers - Real Post"
- Reply: Mike Perry: "Re: Linked Servers - Real Post"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 12:21:19 -0700
Hey all,
I am running SQL 2k on Win 2k. We are using Access as
a front end for our SQL database. My Access app wants to
talk to another Access database, and the way to do this
through SQL is a linked server. True statement? I have
added the linked server I want, and SQL queries it fine,
but not the Access front end. I figured that the remote
login was not getting passed correctly. I went in the
properties for the linked server, under security, and
added all the local users with the remote login of "admin"
and a blank pass. When I try to get the Access front end
to query the linked sever(other Access DB), it says:
"Cannot open the file... It's is already opened by another
user, or you do not have permission to view its data"
Also I tried deleting the server, reestablishing it.
Under the linked server, in properties, security, I tried
leaving the "local server login to remote server login"
clear of users. I then checked the radio that says, "Be
made using this security context" and put a local user
account there and got the message:
"Cannot start your application. The workgroup information
file is missing or opened exclusively by another user"
I also tried putting "admin" and blank pass there also of
course. I know this isn't crazy hard to do, like I said,
SQL Queries it fine. To sum up:
Access(Linked Server) -> SQL -> Access(FrontEnd)
Front end will not communicate with linked server. Thanks
in advance.
Gerard
- Next message: freakazoid: "Re: sp_column 2-tables insert matching columns"
- Previous message: Aaron [SQL Server MVP]: "Re: Setting execute permission on stored procs is inconsistent"
- Next in thread: Mike Perry: "Re: Linked Servers - Real Post"
- Reply: Mike Perry: "Re: Linked Servers - Real Post"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
