Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: 1 user unable to see available queries

    3 computers runing Windows 2000 Pro and Access 2000 on a simple peer-to-peer TCP/IP network. All 3 computers can see and manipulate the tables, forms, macros, etc. Only 1 user is unable to see all the available queries. There are 10 queries available and computers 1 and 3 can see, run and modify all 10 queries. Computer 2 can only see 3 queries and can run and modify the 3 seen queries. There are no restrictive permissions in place. All 3 users have admin rights to all 3 computers and all 3 hard drives. There are no groups or users setup in Access.

    What could be causing computer 2 from being able to see the other 7 queries? I am not talking about query results but the actual query objects themselves.

    Thanks


    Webster

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    First of all I have to ask the stupid question.

    Is this database split BE and FE and do all three computers have the same version of the Front-End.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Sep 2003
    Posts
    2
    The only stupid question is the one not asked. Each computer/user accesses the same combined file. This db has not been split.

    HTH


    Webster

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •