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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switchboard Startup
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! |
#2
|
|||
|
|||
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 "Saf" wrote: 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! |
#3
|
|||
|
|||
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 "Marvin" wrote: 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 "Saf" wrote: 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! |
#4
|
|||
|
|||
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 "Saf" wrote: 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 "Marvin" wrote: 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 "Saf" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disabling switchboard from startup (but keeping it)? | StargateFan | General Discussion | 2 | March 10th, 2005 01:50 PM |
How do I set up a startup switchboard in Access | David1 | New Users | 1 | February 14th, 2005 05:31 PM |
Switchboard Startup | Jan Steenberg | General Discussion | 5 | January 31st, 2005 06:16 PM |
Switchboard on startup | Jessica | Database Design | 1 | December 14th, 2004 02:57 PM |
Switchboards | Jenn Connors | New Users | 1 | October 30th, 2004 09:48 AM |