Prev: vvvv questions
Next: 2 independent criteria in a query
From: Todd C on 4 May 2010 21:37
I created a database with a FE and BE. The FE is totally locked out to
prevent changes. The bypass key is disabled by code which can only be enabled
via the logon on form. The logon form is the first form to open, however
there is a version form that checks the db's current version. So from
startup, the db is trying to take data from the BE.

The directories I placed the BE into, has been substatially changed. I need
to access the FE linked table manager, but without the FE's bypass key
enabled, I cannot get in to do it.

Is there any way to get to the Linked Table Manager in the FE either via
remotely, or by enabling the FE's bypass key remotely. Any help would be
great.
--
Todd
From: NevilleT on 4 May 2010 21:52
Hi Todd
Not sure if this will work, but could you create a new database and import
all the FE forms reports etc.

"Todd C" wrote:

> I created a database with a FE and BE. The FE is totally locked out to
> prevent changes. The bypass key is disabled by code which can only be enabled
> via the logon on form. The logon form is the first form to open, however
> there is a version form that checks the db's current version. So from
> startup, the db is trying to take data from the BE.
>
> The directories I placed the BE into, has been substatially changed. I need
> to access the FE linked table manager, but without the FE's bypass key
> enabled, I cannot get in to do it.
>
> Is there any way to get to the Linked Table Manager in the FE either via
> remotely, or by enabling the FE's bypass key remotely. Any help would be
> great.
> --
> Todd
From: Arvin Meyer [MVP] on 4 May 2010 22:48
Open another database and creat a module. Put this code in it:

Function fReverseBypass()

Dim db As DAO.Database
Dim prop As DAO.Property

Set db = "C:\ Folder\PathToLockedDM.mdb"

db.Properties("AllowByPassKey") = True

End Function

Run it from the Immediate window. You should be able to get in.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Todd C" <ToddC(a)discussions.microsoft.com> wrote in message
news:E6CFD0B8-B95A-429C-972C-2F6605EDF61F(a)microsoft.com...
>I created a database with a FE and BE. The FE is totally locked out to
> prevent changes. The bypass key is disabled by code which can only be
> enabled
> via the logon on form. The logon form is the first form to open, however
> there is a version form that checks the db's current version. So from
> startup, the db is trying to take data from the BE.
>
> The directories I placed the BE into, has been substatially changed. I
> need
> to access the FE linked table manager, but without the FE's bypass key
> enabled, I cannot get in to do it.
>
> Is there any way to get to the Linked Table Manager in the FE either via
> remotely, or by enabling the FE's bypass key remotely. Any help would be
> great.
> --
> Todd


 | 
Pages: 1
Prev: vvvv questions
Next: 2 independent criteria in a query