Permissions problem (I think)

From: CD (CD_at_discussions.microsoft.com)
Date: 08/25/05

  • Next message: Jasper Smith: "Re: PUBLIC db role" 
    Date: Thu, 25 Aug 2005 14:26:09 -0700

    O.k. Here's the background on my situation. We've got an Access program
    running against a SQL 2000 DB. The program was created using Access 2003.
    The user that runs this program had Access 2000 on their PC, which was
    upgraded to Access 2003. One of the first steps the program does is copy
    data from 2 external files into 2 seperate tables(1 table for each file).
    This is done with the TransferText command. When the user runs the program,
    a new table with the same name as the original is created with the user id
    shown as the owner. The data is then copied into this new table instead of
    the one already in the DB. Thus, when the program tries to read the original
    table it fails b/c it is empty. This happens ONLY for this user. If anyone
    else logs in on the users PC, the program works fine. I've tried changing
    every permissions option available, including giving the user FULL rights and
    even making them an enterprise admin. Nothing seems to work. All security
    is the same as it was before we upgraded the user to Access 2003, and it was
    all working before. Any ideas????

  • Next message: Jasper Smith: "Re: PUBLIC db role"

    Relevant Pages

    • Re: Best method to store and retrieve large files in database
      ... and data mining capabilities of SQL. ... You could write a custom iFilter so that SQL FTS can index the files in the ... might be a way of querying Index Server from within SQL to allow you to ... search the external files and link the results to your SQL data. ...
      (microsoft.public.data.ado)
    • Re: Using Design View versus SQL Statement View
      ... John F wrote in ... Mostly, I don't give a rat's ass how the SQL is formatted, because I ... format I specify remains intact. ...
      (microsoft.public.access.queries)