Navigation Pane unhides when creating liked table

Discussion in 'Access Table Design' started by HarkitsMark, Mar 19, 2010.

  1. HarkitsMark

    HarkitsMark Guest

    I have a runtime/accde app to be distributed to users that can't have access
    to the nav pane or objects, and even though I've disabled special keys,
    including shift keys, and turned off the nav pane option, the nav pane
    reappears during app startup. Found out using docmd.transferdatabase acLink
    is the culprit.

    1) does MS know about this and 2) what's the fix if I want to re-create
    table connections during startup behind the scenes?
    --
    Mark A. Kann
    Access Developer/Data Analyst
    Rockford, IL
     
    HarkitsMark, Mar 19, 2010
    #1
    1. Advertisements

  2. HarkitsMark

    Rick Brandt Guest

    HarkitsMark wrote:

    > I have a runtime/accde app to be distributed to users that can't have
    > access to the nav pane or objects, and even though I've disabled special
    > keys, including shift keys, and turned off the nav pane option, the nav
    > pane
    > reappears during app startup. Found out using docmd.transferdatabase
    > acLink is the culprit.
    >
    > 1) does MS know about this and 2) what's the fix if I want to re-create
    > table connections during startup behind the scenes?


    Use DAO to create the link instead of TransferDatabase.
     
    Rick Brandt, Mar 20, 2010
    #2
    1. Advertisements

  3. HarkitsMark

    Maurice Guest

    This is indeed a bug and there's no fix for it. Other solution i heard for
    this problem is to use a timer, do the action (transfer) and after the
    transfer hide the navepane via code again.

    It's a workaround not a solution bu maybe it points you to a tem solution.
    --
    Maurice Ausum


    "HarkitsMark" wrote:

    > I have a runtime/accde app to be distributed to users that can't have access
    > to the nav pane or objects, and even though I've disabled special keys,
    > including shift keys, and turned off the nav pane option, the nav pane
    > reappears during app startup. Found out using docmd.transferdatabase acLink
    > is the culprit.
    >
    > 1) does MS know about this and 2) what's the fix if I want to re-create
    > table connections during startup behind the scenes?
    > --
    > Mark A. Kann
    > Access Developer/Data Analyst
    > Rockford, IL
     
    Maurice, Mar 20, 2010
    #3
  4. HarkitsMark

    HarkitsMark Guest

    Rick

    Interesting suggestion. Can you tell me what that DAO statement/code looks
    like? Does this actually work or is it just an idea? Thanks


    --
    Mark A. Kann
    Access Developer/Data Analyst
    Rockford, IL


    "Rick Brandt" wrote:

    > HarkitsMark wrote:
    >
    > > I have a runtime/accde app to be distributed to users that can't have
    > > access to the nav pane or objects, and even though I've disabled special
    > > keys, including shift keys, and turned off the nav pane option, the nav
    > > pane
    > > reappears during app startup. Found out using docmd.transferdatabase
    > > acLink is the culprit.
    > >
    > > 1) does MS know about this and 2) what's the fix if I want to re-create
    > > table connections during startup behind the scenes?

    >
    > Use DAO to create the link instead of TransferDatabase.
    > .
    >
     
    HarkitsMark, Mar 21, 2010
    #4
  5. HarkitsMark

    Armen Stein Guest

    On Sat, 20 Mar 2010 20:34:01 -0700, HarkitsMark
    <> wrote:

    >
    >Interesting suggestion. Can you tell me what that DAO statement/code looks
    >like? Does this actually work or is it just an idea? Thanks


    If you want an automated DAO approach to relinking tables, you're
    welcome to use our free J Street Access Relinker on our J Street
    Downloads page: http://ow.ly/M56Q

    It handles multiple Access back-end databases, ignores ODBC linked
    tables, and can automatically and silently relink to back-end
    databases in the same folder as the application (handy for work
    databases or single-user scenarios). There's a ReadMe table with
    instructions.

    Armen Stein
    Microsoft Access MVP
    www.JStreetTech.com
     
    Armen Stein, Mar 23, 2010
    #5
  6. If you havent already solved this, try the following...

    I had the same problem, and no amount of re-hiding or setting database properties helped (till the database was restarted).

    As the problem seemed to be specifically caused by the DoCmd.TransferDatabase, its a case of `how to work around this`.

    You can replace this command with CreateTableDef instead (which also allows linking to tables without PK's without access throwing wobbly messages when linking). It works in the same way enough for my purposes.

    Rather than recoding all my code, I just created my own function that a quick search/replace of docmd.transferdatabase would fix. Pseudoycode below...

    MyTransferDatabase acLink, linktype, connectionstring, , srctablename, destinationtablename

    aclink, linktype are pretty errelevant - they just happened to be in my old docmd.transferdatabase version.

    Public Sub MyTransferDatabase(Optional DataTransferType, Optional DatabaseType, Optional DatabaseName, Optional ObjectType, Optional Source, Optional Destination, Optional StructureOnly, Optional StoreLogin)

    Dim tbl As TableDef
    Set tbl = CurrentDb.CreateTableDef(Destination, dbAttachSavePWD, Source, DatabaseName)
    CurrentDb.TableDefs.Append tbl
    CurrentDb.TableDefs.Refresh
    End Sub

    Cheers,

    Martin

    > On Friday, March 19, 2010 11:24 AM HarkitsMark wrote:


    > I have a runtime/accde app to be distributed to users that cannot have access
    > to the nav pane or objects, and even though I have disabled special keys,
    > including shift keys, and turned off the nav pane option, the nav pane
    > reappears during app startup. Found out using docmd.transferdatabase acLink
    > is the culprit.
    >
    > 1) does MS know about this and 2) what is the fix if I want to re-create
    > table connections during startup behind the scenes?
    > --
    > Mark A. Kann
    > Access Developer/Data Analyst
    > Rockford, IL



    >> On Saturday, March 20, 2010 3:12 AM Rick Brandt wrote:


    >> HarkitsMark wrote:
    >>
    >>
    >> Use DAO to create the link instead of TransferDatabase.



    >>> On Saturday, March 20, 2010 5:00 AM Maurice wrote:


    >>> This is indeed a bug and there is no fix for it. Other solution i heard for
    >>> this problem is to use a timer, do the action (transfer) and after the
    >>> transfer hide the navepane via code again.
    >>>
    >>> it is a workaround not a solution bu maybe it points you to a tem solution.
    >>> --
    >>> Maurice Ausum
    >>>
    >>>
    >>> "HarkitsMark" wrote:



    >>>> On Saturday, March 20, 2010 11:34 PM HarkitsMark wrote:


    >>>> Rick
    >>>>
    >>>> Interesting suggestion. Can you tell me what that DAO statement/code looks
    >>>> like? Does this actually work or is it just an idea? Thanks
    >>>>
    >>>>
    >>>> --
    >>>> Mark A. Kann
    >>>> Access Developer/Data Analyst
    >>>> Rockford, IL
    >>>>
    >>>>
    >>>> "Rick Brandt" wrote:



    >>>>> On Tuesday, March 23, 2010 2:31 AM Armen Stein wrote:


    >>>>> If you want an automated DAO approach to relinking tables, you are
    >>>>> welcome to use our free J Street Access Relinker on our J Street
    >>>>> Downloads page: http://ow.ly/M56Q
    >>>>>
    >>>>> It handles multiple Access back-end databases, ignores ODBC linked
    >>>>> tables, and can automatically and silently relink to back-end
    >>>>> databases in the same folder as the application (handy for work
    >>>>> databases or single-user scenarios). There is a ReadMe table with
    >>>>> instructions.
    >>>>>
    >>>>> Armen Stein
    >>>>> Microsoft Access MVP
    >>>>> www.JStreetTech.com



    >>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
    >>>>> SharePoint Workflow Custom Input Forms
    >>>>> http://www.eggheadcafe.com/tutorial...a/sharepoint-workflow-custom-input-forms.aspx
     
    Martin Bastable, Nov 4, 2010
    #6
    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. wslayton
    Replies:
    1
    Views:
    106
    John Vinson
    Nov 1, 2003
  2. Dave Thomas

    Main database navigation form

    Dave Thomas, Feb 12, 2004, in forum: Access Table Design
    Replies:
    3
    Views:
    93
    Jeff Boyce
    Feb 12, 2004
  3. Danny
    Replies:
    6
    Views:
    159
    Danny
    Dec 30, 2004
  4. Justin

    DB Navigation Design

    Justin, Oct 19, 2005, in forum: Access Table Design
    Replies:
    4
    Views:
    70
    Justin
    Oct 20, 2005
  5. Tim Strickland

    Creating a Table from a 2-Field Table

    Tim Strickland, Feb 3, 2006, in forum: Access Table Design
    Replies:
    2
    Views:
    88
    Tim Strickland
    Feb 3, 2006
  6. Peter
    Replies:
    0
    Views:
    113
    Peter
    Feb 8, 2006
  7. surfinmom63

    Access 2007 Navigation Pane

    surfinmom63, Jun 29, 2007, in forum: Access Table Design
    Replies:
    1
    Views:
    101
    Maurice
    Jun 30, 2007
  8. Need Help

    Help with creating query or creating report

    Need Help, Apr 29, 2008, in forum: Access Table Design
    Replies:
    0
    Views:
    159
    Need Help
    Apr 29, 2008
Loading...