Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to edit a locked Access Database

Discussion in 'Information Technology' started by Gineer@gmail.com, Jul 28, 2006.

  1. Gineer@gmail.com

    Gineer@gmail.com
    Expand Collapse
    Guest

    In my company we have an access database application. This application
    (MDE file) when opened, starts up in full screen mode. If you double
    click on the title bar, it does restore it, exposing access behind it
    but with very few active menu items.

    First of all, I need to change the logo on that first screen.

    Secondly I need to change some data in the database.

    The database has been split from the mde file and placed into a
    seperate folder.

    The second point of editing the data (I think) should be possible by
    just opening the mdb file and editing what ever data is required to
    change.

    My problem is with the logo on the front screen. If I open the
    application and press ALT+F11 to pull up the VBA Editor I can see a
    whole collection of modules and forms in the project explorer, but when
    I click on any of them, I get: "Project is unviewable"

    I don't know enough about access to figure this out. I opened access
    and created a small test database and the and then created a MDE file
    using the tools menu. Everything remains editable when I look at the
    code though. Has this thing been locked with a password? If so, how do
    I unlock it?

    Any help would be apreciated.

    The origional developer(s) have since moved on the a better place. Hell
    they may even be dead for all I know.

    Thanks in advance.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Indo-Canadian Sikh Student Selected For Arctic Expedition - Chandigarh Tribune Breaking News Jul 8, 2016
    Sikhi Meditation As A Way Of Life In Sikhism Sikh Sikhi Sikhism Jun 11, 2016
    How To Meditate? | How To Do Naam Simran? | As Per Gurbani? Gurmat Vichaar Jun 1, 2016
    How To Meditate (dhyaan / Simran) ? Am I Doing It All Wrong. I Can't Concentrate And Feel Sleepy Intellectual Articles Mar 25, 2016
    Sikh News Daily Meditation: Clear Mind Breaking News Mar 11, 2016

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    An MDE is tokenized and compiled. It is impossible to edit any forms,
    reports, or code within one.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    <Gineer@gmail.com> wrote in message
    news:1147342204.552430.112490@g10g2000cwb.googlegroups.com...
    > In my company we have an access database application. This application
    > (MDE file) when opened, starts up in full screen mode. If you double
    > click on the title bar, it does restore it, exposing access behind it
    > but with very few active menu items.
    >
    > First of all, I need to change the logo on that first screen.
    >
    > Secondly I need to change some data in the database.
    >
    > The database has been split from the mde file and placed into a
    > seperate folder.
    >
    > The second point of editing the data (I think) should be possible by
    > just opening the mdb file and editing what ever data is required to
    > change.
    >
    > My problem is with the logo on the front screen. If I open the
    > application and press ALT+F11 to pull up the VBA Editor I can see a
    > whole collection of modules and forms in the project explorer, but when
    > I click on any of them, I get: "Project is unviewable"
    >
    > I don't know enough about access to figure this out. I opened access
    > and created a small test database and the and then created a MDE file
    > using the tools menu. Everything remains editable when I look at the
    > code though. Has this thing been locked with a password? If so, how do
    > I unlock it?
    >
    > Any help would be apreciated.
    >
    > The origional developer(s) have since moved on the a better place. Hell
    > they may even be dead for all I know.
    >
    > Thanks in advance.
    >
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    In other words, you need to find the MDB that was used to create the MDE,
    make the desired changes in the MDB and then create a new MDE from it.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:O4pMsVOdGHA.4224@TK2MSFTNGP04.phx.gbl...
    > An MDE is tokenized and compiled. It is impossible to edit any forms,
    > reports, or code within one.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > <Gineer@gmail.com> wrote in message
    > news:1147342204.552430.112490@g10g2000cwb.googlegroups.com...
    > > In my company we have an access database application. This application
    > > (MDE file) when opened, starts up in full screen mode. If you double
    > > click on the title bar, it does restore it, exposing access behind it
    > > but with very few active menu items.
    > >
    > > First of all, I need to change the logo on that first screen.
    > >
    > > Secondly I need to change some data in the database.
    > >
    > > The database has been split from the mde file and placed into a
    > > seperate folder.
    > >
    > > The second point of editing the data (I think) should be possible by
    > > just opening the mdb file and editing what ever data is required to
    > > change.
    > >
    > > My problem is with the logo on the front screen. If I open the
    > > application and press ALT+F11 to pull up the VBA Editor I can see a
    > > whole collection of modules and forms in the project explorer, but when
    > > I click on any of them, I get: "Project is unviewable"
    > >
    > > I don't know enough about access to figure this out. I opened access
    > > and created a small test database and the and then created a MDE file
    > > using the tools menu. Everything remains editable when I look at the
    > > code though. Has this thing been locked with a password? If so, how do
    > > I unlock it?
    > >
    > > Any help would be apreciated.
    > >
    > > The origional developer(s) have since moved on the a better place. Hell
    > > they may even be dead for all I know.
    > >
    > > Thanks in advance.
    > >

    >
    >
     

Share This Page