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

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" <paii@xxxxxxxxxxxxxx> wrote in message
news:scCdnXT7DLEpMSrZnZ2dnUVZ_q2dnZ2d@xxxxxxxxxxxxxx
You can use the autoexec macro, or create a new startup form that opens
the
original after checking for the BE.

<ApexData@xxxxxxxxx> wrote in message
news:1152887684.118737.178490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



ApexData@xxxxxxxxx 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.

<ApexData@xxxxxxxxx> wrote in message
news:1152850315.205442.63930@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • Re: If Hidden BackEnd BE not found then supress error revealing its location?
    ... in my startup forms record source property contains a table I ... any forms or reports that access BE data. ... I have hidden the BackEnd. ... the Backend file. ...
    (comp.databases.ms-access)
  • Re: Access 2007 DB and VPN issues
    ... Do you have any code that runs on startup? ... Have you tried opening the backend via the VPN? ... do most of my programming on the front end while at home by linking the ... after I split the database at ...
    (microsoft.public.access.modulesdaovba)
  • Using a password for data
    ... I would like to simply apply a password to the backend and have ... the frontend apply the password during startup. ... Prev by Date: ...
    (microsoft.public.access.security)