A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Navigation Pane unhides when creating liked table



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 04:24 PM posted to microsoft.public.access.tablesdbdesign
HarkitsMark
external usenet poster
 
Posts: 2
Default Navigation Pane unhides when creating liked table

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
  #2  
Old March 20th, 2010, 08:12 AM posted to microsoft.public.access.tablesdbdesign
Rick Brandt
external usenet poster
 
Posts: 4,354
Default Navigation Pane unhides when creating liked table

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.
  #3  
Old March 20th, 2010, 10:00 AM posted to microsoft.public.access.tablesdbdesign
Maurice
external usenet poster
 
Posts: 1,585
Default Navigation Pane unhides when creating liked table

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

  #4  
Old March 21st, 2010, 04:34 AM posted to microsoft.public.access.tablesdbdesign
HarkitsMark
external usenet poster
 
Posts: 2
Default Navigation Pane unhides when creating liked table

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.
.

  #5  
Old March 23rd, 2010, 07:31 AM posted to microsoft.public.access.tablesdbdesign
Armen Stein[_2_]
external usenet poster
 
Posts: 157
Default Navigation Pane unhides when creating liked table

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.