MS Access Front-End Problem

  • Thread starter Thread starter Mark Thompson
  • Start date Start date
M

Mark Thompson

Hi,

I have a problem and I wondered if anyone here could help.

A colleague has passed me an old Front-End that has been written in
MS-Access. The ability to see the underlying code appears to have been
restricted. The "View" and "Tools" menus are no longer there and there
does not appear to be any way to get around this.

Does anyone here have any ideas as I am tearing my hair out at the
moment!

Thanks,

Mark.

PS: We cannot ask the person who wrote it as he left us a while ago.
 
Mark

Any chance you are working with an .MDE file, rather than an .MDB file?

Regards

Jeff Boyce
<Office/Access MVP>
 
No, It's definitely an .MDB. That's one of the reasons why I am
surprised to find it apparently locked down like this.

Any other ideas?
 
It is standard fair to hide all of the ms-access interface. In fact, you as
a developer should be more surprised when you received a database where all
of the ms-access stuff is in plain view. It is clearly much harder for a end
user to be presented with all of the ms-access interface...and it just a
formula for trouble and confusing the end user.

I always hide all of the ms-access interface..and no code or even security
is needed to do this (this is a basic ms-access skill you will no doubt
master over time).

Try holding down the shift key during program startup.....

And, if that don't work..then try my shift key utility here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
 
Mark

Have you tried importing the objects into a new (empty) .mdb file?

Jeff Boyce
<Office/Access MVP>
 
Did you try opening the file WHILE pressing the shift key? This will bring
you directly to the MS Access database window and by-pass some
initialisations that he may have programmed. Then you can go into the design
of each object (form, report, etc).

I'm also assuming that there is no user-level security programmed into your
MDB. If yes, then you'll need the passwords.

If all else fails, try creating a fresh new MDB file and IMPORT all objects
from your original MDB. This will make you the OWNER of the database and all
the objects within.

Ray
 
Thanks guys,

Holding down the shift key while opening has done the trick!

I knew it would be something straightforward.

Cheers,

Mark.
 
Back
Top