Switchboard Not Found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CJ - 12 May 2007 07:48 GMT

Hi Groupies

I have a Access 2003 database that I have replicated. I have used the
Switchboard Manager to create a switchboard for the database. When I open
one of the replicas, I receive the error message that the "....Jet Database
Engine cannot find the object "Switchboard"....". If I say OK at this
message, then the exact same message shows up again. If I say OK again my
switchboard shows up and everything looks "OK"....although I am suspicious.

Any ideas?

Thanks for the brainwaves

-----------------
CJ

I blame the parents.

Reply to this Message

CJ - 12 May 2007 18:03 GMT

Don't sweat it.

I recreated the replicas but have kept the forms, reports and modules local.

No Error hopefully means No Trouble........;-)

> Hi Groupies
>
[quoted text clipped - 14 lines]
>
> I blame the parents.

Reply to this Message

David W. Fenton - 12 May 2007 23:04 GMT

> I have a Access 2003 database that I have replicated. I have used
> the Switchboard Manager to create a switchboard for the database.
[quoted text clipped - 5 lines]
>
> Any ideas?

A switchboard is a front end object, a form (i.e., an Access object)
and should not be replicated. Your app should be split into front
end (forms/reports/queries/etc.) and back end (data tables only) and
only the back end should be replicated.

The reason for this is that Jet Replication simply does not work
reliably over the long term with Access objects. It is only reliable
with pure Jet objects (tables/queries).

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

Al Whittinghill - 21 May 2007 23:07 GMT

REMOVE ME

On 5/12/07 6:04 PM, in article
Xns992EB7D7D1C0Ff99a49ed1d0c49c5bbb2@127.0.0.1, "David W. Fenton"
<XXXusenet@dfenton.com.invalid> wrote:

>> I have a Access 2003 database that I have replicated. I have used
>> the Switchboard Manager to create a switchboard for the database.
[quoted text clipped - 14 lines]
> reliably over the long term with Access objects. It is only reliable
> with pure Jet objects (tables/queries).

Reply to this Message

David W. Fenton - 22 May 2007 18:01 GMT

> REMOVE ME

From what?

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message