Access 2000/2002 Problems

[Tom]

All:

I’m having problems with two databases misbehaving and at a loss as to
how to fix.

Situation:
• Both are MS Access 2000 format .mdb connected to SQL Server tables
• Development machine has both A2002 and A2000 installed
• Target machine has only A2000 installed

Symptoms:
• The dbs works fine when opened with either A2002 or A2000 from
development machine
• The dbs hang if I have last opened the .mdb in A2002 on the
development machine before publishing.
• The dbs don’t hang if I open the .mdb in A2000 before publishing
• The dbs work fine from target machine if I put a breakpoint in the
startup code and step thru all the lines till the switchboard is
displayed

Startup Routine:
• There is no autoexe macro
• frmSplash is set as the startup form
• the load event for frmSplash hides all extraneous toolbars using
Application.CommandBars("Some Toolbar Name").Visible = False and sets
the timer at 2 seconds
• the timer event does the following:
1. Application.SetOption "showwindowsintaskbar", False
2. Call subConnectSQL 'connect to the SQL tables
3. Call subVersionControl 'check versioning
4. MsgBox "Linked to the XXXX database.", vbOKOnly + vbInformation,
"XXXX"
5. DoCmd.Close acForm, "frmsplash"
6. DoCmd.OpenForm "Switchboard"

Other information:
• This happens with multiple databases all using the same general
design and startup routine
• One of the databases hangs in subVersionControl, the other makes it
to Line 5, but no further.

This is driving me nuts… Any ideas? I figure the odds are that there
is something wrong with Access on either the development machine or
the target machine – but which one?

Thanks for any ideas.

Tom

 

[Jerry Whittle]

You probably have different references set on the various computers. Check
out the web page below for some general guidance.

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