Re: Unlock database

Tech-Archive recommends: Fix windows errors by optimizing your registry

MJL <MJL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I don't know whether I'm the right forum or not. I'm facing a problem at
work - there's a database I need to access to make revisions to the data as
well as adding data. The person who created this database has left the
company and will not divulge any information pertaining to this database.
I've tried to import but still cannot make any changes to it. I've looked at
the most obvious places and nothing shows that it's been locked.

This is what happens when I open the file up - I'm not asked for any
passwords - I'm able to view the form but cannot make any changes.

How would I go about 'unlocking' this document?

This sounds like the database has been made into an MDE.

MDE to MDB Conversion Service for Microsoft® Access
http://www.everythingaccess.com/mdeconversion.htm

Converting a Microsoft Access MDE file back into an MDB file. Section
2 at http://www.access.qbuilt.com/html/faq.html

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: making an MDE file
    ... Then try to make the MDE. ... Microsoft Access 2003 VBA Programmer's Reference ... > I'm not quite sure what I'm missing. ... > I'm the owner of everything in the database. ...
    (microsoft.public.access.security)
  • Re: Cant make an MDE file.
    ... "Microsoft Access Was Unable to Create an MDE Database" Error ... There are other articles available depending on your version. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 2002 command line options.
    ... > database Opens the specified database. ... > /excl Opens the specified database for exclusive access. ... > /user user name Starts Microsoft Access using the specified user name. ... To compact to a different name, specify a target ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Cant access code
    ... See http://www.QBuilt.com for all your database needs. ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... Create a new database file and import all objects except the corrupt form. ... If you have a recent backup, import this form from the backup and check ...
    (microsoft.public.access.modulesdaovba)
  • Re: I cant generate one Module MDE in Access 2002,2003.
    ... extension ".mde", i obtain the next message from Access: ... This error is usually associated with compiling a large database into an MDE ... There is no accurate method to estimate the number of TableIDs the Jet ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.security)