Switchboard Startup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

We have an Access Database (2002 version) used by around 35 users, one
particular user who has the 2003 version is having a problem whereby when he
opens the database the default switchboard form opens and then closes itself.
(Is it a Cache Problem)
However, When I changed the default startup form from switchboard to system
log form it opens up ok. Every other user irrespective of versions can get on
to the default switchboard at startup. Please can you offer any ideas and
possible solutions to this problem.

Thanks!
 
Saf,

I don't know what the cause of this problem is, but I have a few ideas (they
would work best if you can get on a PC with 2003 installed):

1. Can you tell if the form is actually closed or is hidden?
2. Perhaps a runtime error is causing the problem. Maybe you can trap the
errors and have them written to a text file. If you can check it on a PC with
2003 yourself, maybe you can debug.print any errors to the immediate window.
3. You might be able to determine the source of the problem better if you
can open the database in 2003 in Bypass mode, then open the form from the
database window.

Hope this helps,

Marvin
 
Hi Marvin,

1) I think the form is hidden but the system is thinking about something at
startup. (WILD GUESS - probably something to do with the users last
successfull login, probably the form wasnt closed successfully, and now at
startup the DB sees that a form of that name is already open????)

2) Please can you advise on how I could go about trapping errors and having
them written to a text file.

3) Have tried the third option but couldnt open the form from the database
window. I've also tried renaming the table (which causes other violations)
but this doesnt seem to work aswell.

Thanks

Saf
 
Here is a page from AllenBrowne.com that might have something that works for
you: http://allenbrowne.com/ser-23a.html. It discusses how to log error
messages to a table. Especially useful if you can't duplicate the environment.

You might try some of this (especially if the form is corrupted in some way):
1.
Compact/Repair the database
AND / OR
2.
Compile the database (in the VBA environment). Fix any compilation
errors. Compact/Repair again.
AND / OR
3.
- Make a backup copy of your database (for safe keeping)
- Create a new (temporary) database
- Import the form into the temporary database
- delete the form in your (production/test) database
- Re-import the form into your database from the temporary one
4.
- save the form to text using SaveAsText
- replace the form using LoadFromText
5.
- Import everything into a completely new database (maybe use 2003
version and convert back to 2000) and check to see if the problem still occurs
6.
- If all else fails, you might try rebuilding the form by copy/paste-ing
the controls, testing as you go to see when the problem reoccurs.

Marvin
 
Back
Top