Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1189
  • Last Modified:

Problems with subforms in Access 2000 Runtime

I have a database that loads fine in Access 2000, but when I load it in Access 2000 runtime, several of the subforms will not even load.

To debug it so far, I put code into the form_load events for the subforms that shows a message box when it is triggered.  When I load it in 2000, the subforms load first, followed by the load event on the form that holds the subforms, BUT

When I load it in Runtime, the subforms form load events don't even trigger before the main form's do, causing errors when it tries to refer to the subform's objects.

Any idea why it would bypass loading the subforms altogether, as it seems to be doing?  Is there a limit to the number of subform objects that can be loaded at a time by the runtime version?  ...because I have a whole bundle of 'em in here.  Any suggestions are very welcome.

Thanks!
0
earthman100
Asked:
earthman100
  • 3
  • 3
  • 3
  • +2
1 Solution
 
jjafferrCommented:
Hi earthman100,

if you like, you can email me you mdb after zipping it, and I will have a look at it.
click on my name to see my email in  my profile.
send me a brief desciption of the problem too.

jaffer
0
 
earthman100Author Commented:
Jaffer,

As this is a commercial application and I have partners that would prefer not to have the source code "on the street" I respectfully cannot go that route.  No offense, but if you have any suggestions that may steer me in the right direction in this case, that would be great instead.  

Just to clarify, the app. runs fine in the full version(s) of Access, just not in the runtime 2000.
0
 
Alan WarrenCommented:
Hi

re: because I have a whole bundle of 'em in here
not familiar with this problem at all, but could be related to the jet Error 3014 - Can't Open Any More Tables

http://www.mvps.org/access/bugs/bugs0010.htm

Alan
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Alan WarrenCommented:
Hi earthman100

re: causing errors when it tries to refer to the subform's objects
again, not sure what sort of referencing you are doing here but you may be able to reverse the process instead of sucking the information from the sub-form you could push the information to the parent

Me.Parent.txtSomeControl = Me.somecontrol

Alan

0
 
nico5038Commented:
Hmm, some thoughts:

1) Is the .mdb "clean compiled" (Run "Debug/compile all modules" when in VBA code)
2) Did you decompile the database before creating the runtime package:
   http://www.granite.ab.ca/access/decompile.htm
3) Do you work on the same Windows OS as where the runtime is implemented ?
    (XP gives me errors on A2000 databases that work under W98/W ME)
4) Are the references OK on the machines you install the runtime ?

Nic;o)
0
 
jjafferrCommented:
Sorry earthman100, I didn't read the question correctly the first time, I thought it was a normal Form/SubForm.

Two things:
1-
Are the ActiveX components included in your run-time distribution?
2-
try upgrading
Microsoft Data Access Components (MDAC) 2.8 Software Development Kit
http://www.microsoft.com/downloads/details.aspx?familyid=5067faf8-0db4-429a-b502-de4329c8c850&displaylang=en

jaffer
0
 
earthman100Author Commented:
Thank you all for your suggestions so far.

References:  I have checked the references on the Runtime testing machine and they all seem valid.  All of the ActiveX controls are running fine.  Two of the three subforms that aren't loading properly have no activex controls on them.

Recreating Forms:  I have removed the subforms from the main form, compiled, compacted, decompiled, and then recreated them, with no luck.  

OS:  I am running the XP Home on the test machine and XP PRO on the development machine

Oddly enough, it just seems to have trouble with the three subforms and no others, even though there are about a dozen other subforms on the main form that load fine.  I am currently going back through my backups to see when they stopped loading, to try and find some clue.  ANy other suggestions offered would be of great help.  Thanks!

0
 
nico5038Commented:
Hmm, under XP Access acts differents as under W98/W2000 :-(
I've had trouble with parameter popups when closing a form (http://www.experts-exchange.com/Databases/MS_Access/Q_20662877.html) and looks to me this is a problem in the same "corner" of form eventhandling.

Nic;o)
0
 
earthman100Author Commented:
I have gotten as far as realizing that when I remove everything from the offending form (controls and code), it still won't load, but if I create a new form and copy and paste all the controls and code into it, it seems to work now.

So....this is the route I am taking to fix it - rebuilding all three forms.  I have no idea why they have done this, but I am on the road to recovery.  

Thanks to you all anyways for your suggestions, I think I can make it from hgere on in!

0
 
Alan WarrenCommented:
Thanks for the feed-back earthman100, it all helps.
Glad you are on top of it.

Alan
0
 
moduloCommented:
A request has been made in Community Support to close this question:

http:Q_20990575.html 

If there are no objections, a moderator will finalise this question after 4 days by:

- PAQ-ing the question and refunding 500  points

Please leave any recommendations here.

modulo

Community Support Moderator
Experts Exchange
0
 
nico5038Commented:
No problem.

Nic;o)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now