Re: Can't query linked Access database specified by UNC

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/19/05

  • Next message: MoreThanInsane: "Re: Replication Not working for a table" 
    Date: Tue, 18 Jan 2005 16:11:38 -0700

    Yes...but you still need to check the permissions - the
    whole ldb thing. And you need to make sure the permissions
    are explicitly set. Logging on and starting access and
    opening the database manually is not the same thing.

    -Sue

    On Tue, 18 Jan 2005 16:07:49 -0600, "Vadim Rapp"
    <vrapp@nospam.polyscience.com> wrote:

    >Hello Sue:
    >You wrote on Tue, 18 Jan 2005 13:23:38 -0700:
    >
    > SH> The first is to do is ensure that the database is not being
    > SH> opened exclusively by other users. If that's all fine then
    > SH> the error is likely related to permissions.
    >
    >I thought that as well; that's why, as I wrote, I manually logged on the sql
    >server machine, with the same userid as sqlserver; started Access and opened
    >the same database successfully.
    >
    >In other words, I manually did exactly what sql server couldn't do, with the
    >same login id on the same machine.
    >
    >Vadim

  • Next message: MoreThanInsane: "Re: Replication Not working for a table"

    Relevant Pages

    • ADP, Application Role, and objects
      ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Execute Persmission denied on object sp_OACreate
      ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
      (microsoft.public.sqlserver.security)
    • Re: Newbie: I dont understand user permissions for table access
      ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
      (microsoft.public.sqlserver.server)
    • Re: Execute Persmission denied on object sp_OACreate
      ... SQL Server is creating a job behind the scenes. ... SA account password and gaining access to the database. ... > SQL Server doesn't check permissions on indirectly referenced objects as ... > the proxy account security context for non-sysadmin users from Enterprise ...
      (microsoft.public.sqlserver.security)
    • Re: Security question ..
      ... What I want to prevent is any access to the database accept through our ... application unless you have elevated permissions. ... Authentication, if he is smart enough to create an NT Auth ODBC connection ... passes through to the database or to use SQL Server authentication. ...
      (microsoft.public.sqlserver.server)
    • Quantcast