If Hidden BackEnd BE not found then supress error revealing its location?

[ApexData]

Hello

Split DB (FE & BE) Linked. FE compiled to MDE.

For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access Error
reports exactly where the Backend is. This blows my attempt at hidding
the Backend file. I have tried to use the DIR() statement to look for
the BE in my FormOpen of my 1st form but it seems to be ignored.

Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden ?

Thanks Greg

[david epsom dot com dot au]

Show us the code for your DIR test.

(david)

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...

Hello

Split DB (FE & BE) Linked. FE compiled to MDE.

For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access Error
reports exactly where the Backend is. This blows my attempt at hidding
the Backend file. I have tried to use the DIR() statement to look for
the BE in my FormOpen of my 1st form but it seems to be ignored.

Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden ?

Thanks Greg

[ApexData]

Private Sub Form_Open(Cance l As Integer)
On Error GoTo Err_Handler 'I also shut off the
err_handler
MsgBox Len(Dir("c:\bfd x\nlf94p.mdb")) ' test for file

ERROR MESSAGE I'm receiving:
Could not find file 'c:\bfdx\nlf94p .ocx'.

I change the name of the Backend DB to deliberately test for the
missing file. Then the
code runs in the Form_Open and I recieve the error message. This Error
seems to occur before any code in the Form_Open executes. I know the
DIR statement works fine, because it properly tests for the file when
the file is renamed correctly.

david epsom dot com dot au wrote:

Show us the code for your DIR test.

(david)

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...

Hello

Split DB (FE & BE) Linked. FE compiled to MDE.

For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access Error
reports exactly where the Backend is. This blows my attempt at hidding
the Backend file. I have tried to use the DIR() statement to look for
the BE in my FormOpen of my 1st form but it seems to be ignored.

Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden ?

Thanks Greg

[paii, Ron]

You need to change the startup in your FE to check for the BE before opening
any forms or reports that access BE data.

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...

Hello

Split DB (FE & BE) Linked. FE compiled to MDE.

For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access Error
reports exactly where the Backend is. This blows my attempt at hidding
the Backend file. I have tried to use the DIR() statement to look for
the BE in my FormOpen of my 1st form but it seems to be ignored.

Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden ?

Thanks Greg

[ApexData]

Ron

I don't understand what you mean. I do not see any options in the
"Startup" allowing me to check for the BE. What I want to do is look
for the BE when the FE starts. I figured the place to do this is the
Form_Open of the FE. If I make this work, then I'll know if the BE
exists, or is gone. Then I can shut my app down. I DoNot want the FE
reporting that the BE is missing, and then displaying its path. For
security reasons, this will reveal my hidden backend. Not Good.

Thanks for Responding


paii, Ron wrote:

You need to change the startup in your FE to check for the BE before opening
any forms or reports that access BE data.

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...

Hello

Split DB (FE & BE) Linked. FE compiled to MDE.

For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access Error
reports exactly where the Backend is. This blows my attempt at hidding
the Backend file. I have tried to use the DIR() statement to look for
the BE in my FormOpen of my 1st form but it seems to be ignored.

Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden ?

Thanks Greg

[ApexData]

Ron

Sorry! I do understand what you mean!
However, in my startup forms record source property contains a table I
need to use.
Is there a way around this, like calling it form code. Or do I need to
use the autoexec macro, or load a phantom form before my startup form ?
Any suggestions?

Greg

Ap******@gmail. com wrote:

Ron

I don't understand what you mean. I do not see any options in the
"Startup" allowing me to check for the BE. What I want to do is look
for the BE when the FE starts. I figured the place to do this is the
Form_Open of the FE. If I make this work, then I'll know if the BE
exists, or is gone. Then I can shut my app down. I DoNot want the FE
reporting that the BE is missing, and then displaying its path. For
security reasons, this will reveal my hidden backend. Not Good.

Thanks for Responding


paii, Ron wrote:

You need to change the startup in your FE to check for the BE before opening
any forms or reports that access BE data.

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...

Hello
>
Split DB (FE & BE) Linked. FE compiled to MDE.
>
For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access Error
reports exactly where the Backend is. This blows my attempt at hidding
the Backend file. I have tried to use the DIR() statement to look for
the BE in my FormOpen of my 1st form but it seems to be ignored.
>
Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden ?
>
Thanks Greg
>

[paii, Ron]

You can use the autoexec macro, or create a new startup form that opens the
original after checking for the BE.

<Ap******@gmail .comwrote in message
news:11******** **************@ p79g2000cwp.goo glegroups.com.. .

Ron

Sorry! I do understand what you mean!
However, in my startup forms record source property contains a table I
need to use.
Is there a way around this, like calling it form code. Or do I need to
use the autoexec macro, or load a phantom form before my startup form ?
Any suggestions?

Greg

Ap******@gmail. com wrote:

Ron

I don't understand what you mean. I do not see any options in the
"Startup" allowing me to check for the BE. What I want to do is look
for the BE when the FE starts. I figured the place to do this is the
Form_Open of the FE. If I make this work, then I'll know if the BE
exists, or is gone. Then I can shut my app down. I DoNot want the FE
reporting that the BE is missing, and then displaying its path. For
security reasons, this will reveal my hidden backend. Not Good.

Thanks for Responding


paii, Ron wrote:

You need to change the startup in your FE to check for the BE before

opening

any forms or reports that access BE data.
>
<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...
Hello

Split DB (FE & BE) Linked. FE compiled to MDE.

For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access

Error

reports exactly where the Backend is. This blows my attempt at

hidding

the Backend file. I have tried to use the DIR() statement to look

for

the BE in my FormOpen of my 1st form but it seems to be ignored.

Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden

?

Thanks Greg

[ApexData]

Ron

I used the autoexec. But, I still get the Error Message First! Then
the result from the AutoExec macro reports that the file is missing.
NotGood?
paii, Ron wrote:

You can use the autoexec macro, or create a new startup form that opens the
original after checking for the BE.

<Ap******@gmail .comwrote in message
news:11******** **************@ p79g2000cwp.goo glegroups.com.. .

Ron

Sorry! I do understand what you mean!
However, in my startup forms record source property contains a table I
need to use.
Is there a way around this, like calling it form code. Or do I need to
use the autoexec macro, or load a phantom form before my startup form ?
Any suggestions?

Greg

Ap******@gmail. com wrote:

Ron
>
I don't understand what you mean. I do not see any options in the
"Startup" allowing me to check for the BE. What I want to do is look
for the BE when the FE starts. I figured the place to do this is the
Form_Open of the FE. If I make this work, then I'll know if the BE
exists, or is gone. Then I can shut my app down. I DoNot want the FE
reporting that the BE is missing, and then displaying its path. For
security reasons, this will reveal my hidden backend. Not Good.
>
Thanks for Responding
>
>
>
>
paii, Ron wrote:
You need to change the startup in your FE to check for the BE before

opening

any forms or reports that access BE data.

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...
Hello
>
Split DB (FE & BE) Linked. FE compiled to MDE.
>
For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access

Error

reports exactly where the Backend is. This blows my attempt at

hidding

the Backend file. I have tried to use the DIR() statement to look

for

the BE in my FormOpen of my 1st form but it seems to be ignored.
>
Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is hidden

?

>
Thanks Greg
>

[Rick Brandt]

Ap******@gmail. com wrote:

Ron

I used the autoexec. But, I still get the Error Message First! Then
the result from the AutoExec macro reports that the file is missing.
NotGood?

You must run this test BEFORE any attempt is made by the app to hook into the
back end file. If you have a startup form specified in Options - Startup that
form will be loaded prior to the execution of the AuotExec macro.

The solution is to specify a form in startup that is hidden and unbound and that
has the sole purpose of running this test. If the file is found then that form
can close itself and open your "real" startup form.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[paii, Ron]

A new form would be my choice because the Dir() function can fail if the
path is invalid, which would crash your application if run from a macro.

"paii, Ron" <pa**@packairin c.comwrote in message
news:sc******** *************** *******@athenet .net...

You can use the autoexec macro, or create a new startup form that opens

the

original after checking for the BE.

<Ap******@gmail .comwrote in message
news:11******** **************@ p79g2000cwp.goo glegroups.com.. .

Ron

Sorry! I do understand what you mean!
However, in my startup forms record source property contains a table I
need to use.
Is there a way around this, like calling it form code. Or do I need to
use the autoexec macro, or load a phantom form before my startup form ?
Any suggestions?

Greg

Ap******@gmail. com wrote:

Ron
>
I don't understand what you mean. I do not see any options in the
"Startup" allowing me to check for the BE. What I want to do is look
for the BE when the FE starts. I figured the place to do this is the
Form_Open of the FE. If I make this work, then I'll know if the BE
exists, or is gone. Then I can shut my app down. I DoNot want the FE
reporting that the BE is missing, and then displaying its path. For
security reasons, this will reveal my hidden backend. Not Good.
>
Thanks for Responding
>
>
>
>
paii, Ron wrote:
You need to change the startup in your FE to check for the BE before

opening

any forms or reports that access BE data.

<Ap******@gmail .comwrote in message
news:11******** *************@3 5g2000cwc.googl egroups.com...
Hello
>
Split DB (FE & BE) Linked. FE compiled to MDE.
>
For security reasons, I have hidden the BackEnd. However, If the
network is down or the FE can't find the Backend, then an Access

Error

reports exactly where the Backend is. This blows my attempt at

hidding

the Backend file. I have tried to use the DIR() statement to look

for

the BE in my FormOpen of my 1st form but it seems to be ignored.
>
Now do I detect ,right away, if the BackEnd is found so that I can
close down the app without it revealing where the BE file is

hidden

?

>
Thanks Greg
>