Switchboard won't open, not even in design

  • Thread starter Thread starter MrDavePet
  • Start date Start date
M

MrDavePet

I have a simple Access-2003 database that I created.
It was working fine UNTIL I added a control to the Switchboard that
would display the user name and computer name using the Environ
variable.

textbox "User", data control source =environ(UserName) & " on " &
environ(ComputerName)

Now the Switchboard won't open, not even in design.
No errors, just no response.
How can I get back in to revise it?
 
Hi,
hold down the shift key while you open the database and keep it open until
the database is opened.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
I have a simple Access-2003 database that I created.
It was working fine UNTIL I added a control to the Switchboard that
would display the user name and computer name using the Environ
variable.

textbox "User", data control source =environ(UserName) & " on " &
environ(ComputerName)

Now the Switchboard won't open, not even in design.
No errors, just no response.
How can I get back in to revise it?
Click to expand...

Hm, looks like the form is damages somehow.

Try this to make sure am I right or not. Create blank database and try
to import that form (Access 2003: File > Get External Data > Import,
Access 2007: somewhere in the ribbon). If it cannot import it, then
the form is damaged.

In this case, import ALL other objects to new database and re-create
switchboard form.

Regards,
Branislav Mihaljev
Microsoft Access MVP
 
Hm, looks like the form is damages somehow.

Try this to make sure am I right or not. Create blank database and try
to import that form (Access 2003: File > Get External Data > Import,
Access 2007: somewhere in the ribbon). If it cannot import it, then
the form is damaged.

In this case, import ALL other objects to new database and re-create
switchboard form.

Regards,
Branislav Mihaljev
Microsoft Access MVP
Click to expand...

You are right. The form won't export or import.
Broken.
I wonder how I crashed it?
 
You are right.  The form won't export or import.
Broken.
I wonder how I crashed it?
Click to expand...

Hi,

Who knows, there are various ways to damage object or whole database.
General advice is to install all the updates for your MS Office and
all the latest hotfixes and to make backup copy from time to time,
like once in a hour during development, just to make sure you won't
loose much of your work if whole db crashes. Also try not to use any
of the ActiveX controls if possible.

So far you will need to create empty DB and import all the objects and
re-create switchboard.

Regards,
Branislav Mihaljev
Microsoft Access MVP
 
Back
Top