How to fix a database that I din't design?

  • Thread starter Thread starter Chely
  • Start date Start date
C

Chely

Hi, everybody. I hope somebody can help me. I new in Access, my boss
wants me to make some corrections to a database they used, and that an
ex-employee designed. I being trying to find files that can show me the
design window of the database, but i only see the database as any user
and i can go behind it. Please help me. how i can go behind it so i can
fix the problems. Thanks
 
from your post, it sounds like you know little to nothing about Access. i
don't intend to be unkind, or demean you, hon, because there's never shame
or apology for not knowing something - and every Access developer of any
skill level started from that very place. but troubleshooting a database
built by someone else can test the skills of even an experienced developer -
it's not a place to start "dabbling", especially in a working database being
used in a business. my best recommendation is that you be honest with your
boss and tell him/her that you don't possess the skills to do what s/he's
asking of you. if you intend to move forward regardless, the only advice i
have to offer you is to make a copy of the working database - when nobody
else is using it - and mess with the COPY only.

hth
 
Hi, everybody. I hope somebody can help me. I new in Access, my boss
wants me to make some corrections to a database they used, and that an
ex-employee designed. I being trying to find files that can show me the
design window of the database, but i only see the database as any user
and i can go behind it. Please help me. how i can go behind it so i can
fix the problems. Thanks
Click to expand...

Do read and consider Tina's excellent advice. You've been handed a big
can of worms, and I hope you don't have to consume too many of them.

You can - perhaps, depending on how thorough the developer was -
bypass the startup code and get into design view by holding down the
SHIFT key while opening the database; or perhaps by pressing F11 when
the database is open. You must be in the "MDB" file to do this - if
you're using a "MDE" file (look at the extension in Windows Explorer)
then you *cannot* make design changes to it, you must obtain a copy of
the original MDB.

John W. Vinson[MVP]
 
Back
Top