Not Linked to BE database at startup

[sk]

I just finished splitting my database and now I am having a different issue.
The front end will be used to connect to several different BE (depending on
the project being worked) I have the code to make the connection as needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[sk]

Forgot to add it is a 2007 db

Thanks again

 

[sk]

found it, just needed to clear the Record Source for the form.

 

[å¼ å°å»º]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[å¼ å°å»º]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[å¼ å°å»º]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[å¼ å°å»º]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[å¼ å°å»º]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[å¼ å°å»º]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.

 

[De Jager]

I just finished splitting my database and now I am having a different
issue.
The front end will be used to connect to several different BE (depending
on
the project being worked) I have the code to make the connection as
needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code
in
load event before it errors if it cannot find the BE it was connected to.

What I want to happen is have the form load and post a msg saying that it
is
not connected, then allow the connection to be made via other code.

Any help would be greatly appreciated.