Access 2013 - Switchboard Error on Open

Question

DB is set to open Switchboard on open. 

When the DB is opened, I get a message that says "The command or action 'Requery' isn't available now." I click OK on this message, and another window opens called "Macro Single Step"

Macro Name: Switchboard : Form : OnOpen : Embedded Macro

Action Name: Requery

The only option you can click on is "Stop All Macros"

If I double click on the Form Switchboard it opens just fine. 

Any idea what gives?

Answer 1

Next step would be to debug the startup code. Applications are started one of two ways:

1. File > Options > Current Database > Display form
2. AutoExec macro

Inspect the code. Set breakpoints. Isolate the problem to a single line of code. Maybe then the solution already becomes apparent, or we may be able to make additional suggestions.

Requery is a procedure that is widely overused, so commenting it out would certainly be one step to try.

Answer 2

Hi Tom,

I'm having the same issue and my database is split.  What would be my next step in addressing this requery issue?

Thanks

Answer 3

"As far as I know"

It's easy to confirm: does your application database have table objects, or linked table object?

Or said another way: when you run the Linked Table Manager, does it list (linked) tables or not?

Answer 4

As far as I know it is not split. I did not create this database.

Answer 5

Is this a "split" database? If so, are you using any code to link to the BE at startup? Just curious...