Excel pivot pointing to access

Discussion in 'Microsoft Access Getting Started' started by we7dude@hotmail.com, Jan 26, 2011.

  1. Guest

    There is an access database that I update daily, and there is a excel
    pivot pointing to it. as soon as someone have the excel open, I become
    a read only in access, which is no letting me to update. any idea how
    to do like kick people off the access file (telling people physically
    is not possible). thanks a bunch..
     
    , Jan 26, 2011
    #1
    1. Advertisements

  2. Ed Robichaud Guest

    Opening the *.LDB file in an editor (like Note Pad) will let you see who's
    logged in. You could email or IM them. FMS (and others) have some
    management tools that will handle identifying and notifying users.


    <> wrote in message
    news:...
    > There is an access database that I update daily, and there is a excel
    > pivot pointing to it. as soon as someone have the excel open, I become
    > a read only in access, which is no letting me to update. any idea how
    > to do like kick people off the access file (telling people physically
    > is not possible). thanks a bunch..
     
    Ed Robichaud, Jan 28, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Greta

    Pivot Tables in Access

    Greta, Dec 9, 2003, in forum: Microsoft Access Getting Started
    Replies:
    4
    Views:
    190
    Michel Walsh
    Dec 10, 2003
  2. airdale

    Pivot toolbar grayed out access 2002

    airdale, Jan 3, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    207
    airdale
    Jan 3, 2004
  3. punki van via AccessMonster.com

    copy Pivot Chart in access and paste in word

    punki van via AccessMonster.com, Jan 4, 2005, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    1,789
    Guest
    Jan 14, 2005
  4. Guest

    Pivot Table View not available - Access 2000

    Guest, Mar 26, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    254
    Guest
    Mar 27, 2005
  5. Guest

    how to link access data to excel's pivot table

    Guest, Jun 25, 2006, in forum: Microsoft Access Getting Started
    Replies:
    5
    Views:
    566
    Duane Hookom
    Jun 27, 2006
  6. Guest

    Export Pivot chart to excel

    Guest, Oct 23, 2007, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    575
    Guest
    Oct 23, 2007
  7. CM

    Access 2002, Pivot Table & decimals

    CM, May 15, 2008, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    319
  8. Access Noob

    Pivot table entry forms in Access 2003(or 2007) and performance is

    Access Noob, Dec 3, 2009, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    375
    Jerry Whittle
    Dec 3, 2009
Loading...