Re: Linked Access Server - works on server but not from workstatio

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?
>>
>>
>>


.

Relevant Pages

  • Re: T-SQL is not quite there yet
    ... StoredProc1 does the same thing to insert data from StoredProc2. ... I assume a lot of this has to do with that the linked server may not ... SQL Server instance, one could surely wish that SQL Server had special ...
    (microsoft.public.sqlserver.programming)
  • Re: Support team security
    ... to view Linked Server properties (this is a tool requirement not a SQL ... Jasper Smith (SQL Server MVP) ... SQL Server Agent Job Schedule and Job history ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2000 linked server problem
    ... of SQL Server 2000 to fix some known bugs on the SQL Server side. ... the both two SQL Server instances (local and linked server), ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)
  • Re: Setting up Linked server to MsAccess
    ... This will set the security so anyone using the linked server ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Re: MAS90
    ... To set up a linked server from SQL Server 2000 to MAS90 using Enterprise ...
    (comp.databases.ms-access)
Loading