Navigation Pane unhides when creating liked table

[HarkitsMark]

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?

 

[Rick Brandt]

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.

 

[Maurice]

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.

 

[HarkitsMark]

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

 

[Armen Stein]

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

 

[Martin Bastable]

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