Re: Linked Access Server - works on server but not from workstatio
- From: "Mark" <swozz_@xxxxxxxxxxx>
- Date: Thu, 19 Jan 2006 17:11:48 -0000
Lori,
On the server that hosts SQL Server.
--
Best regards
Mark Baldwin
"Lori g" <Lorig@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AAA7C616-6BD1-48B6-8303-FC97D6080117@xxxxxxxxxxxxxxxx
> Where should i attempt this; the server hosting SQL Server, or the server
> where the Access database is located (different departments handle
> different
> servers)
>
> "Mark" wrote:
>
>> Lori,
>>
>> This should resolve your problem...
>>
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;814398
>>
>> --
>> Best regards
>> Mark Baldwin
>>
>> "Lori g" <Lorig@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:6AF987B9-BD70-4884-9FBB-42B34994203F@xxxxxxxxxxxxxxxx
>> >I am set up as an administrator on both the box and in SQL Server (using
>> > Windows login), and the properties of the linked server (security tab
>> > on
>> > the
>> > linked server) is "SELF". The only thing that i don't have admin rights
>> > to
>> > is
>> > the folder and server containing the Access Database that is linked. I
>> > was
>> > able to establish the connection if I linked the database under "local"
>> > server in EM (logged into my machine).
>> >
>> > "Mark" wrote:
>> >
>> >> I have not had any dealings with using Access as a linked server but I
>> >> suspect it's a security issue - have you had a look at the security
>> >> properties of the linked server (security tab on the linked server
>> >> dialog
>> >> when adding it from Enterprise Manager)?
>> >>
>> >> --
>> >> Best regards
>> >> Mark Baldwin
>> >>
>> >> "Lori g" <Lori g@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:1E819D09-4A1D-4FF6-BBDD-BAA25340BA4A@xxxxxxxxxxxxxxxx
>> >> > In SQL 2000, I have a linked Access database that you can only run
>> >> > queries/stored procedures from, or view the tables, if you are
>> >> > logged
>> >> > into
>> >> > the server remotely. I have the server registered on my machine but
>> >> > the
>> >> > following error is generated when I try to view the tables or run a
>> >> > query...
>> >> >
>> >> > "Error 7399: OLE DB provider Microsoft.Jet.OLEDB.4.0 reported an
>> >> > error"
>> >> >
>> >> > I've looked at BOL and tried numerous things, but no luck. I get the
>> >> > same
>> >> > error when i try to run a job containing the stored procedure when
>> >> > logged
>> >> > into the server remotely as well.
>> >> > Anyone?
>> >>
>> >>
>> >>
>>
>>
>>
.
- References:
- Prev by Date: Re: Linked Access Server - works on server but not from workstatio
- Next by Date: RE: LIKE Clause in OLEDB 2005
- Previous by thread: Re: Linked Access Server - works on server but not from workstatio
- Next by thread: RE: LIKE Clause in OLEDB 2005
- Index(es):
Relevant Pages
|
Loading
