Switchboard won't open, not even in design

[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?

 

[Jeanette Cunningham]

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

 

[banem2]

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?

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

 

[MrDavePet]

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

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

 

[banem2]

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

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