Unlock database

[MJL]

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?

I'm a newbie at Access and the version we have at work is 2003.

Any help is greatly appreciated.

 

[Shar]

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?

I'm a newbie at Access and the version we have at work is 2003.

Any help is greatly appreciated.

 

[Scott McDaniel]

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.

Sounds to me like the "person who created this database" needs a phone call from the company's attorney, assuming the
database was built on company time or is owned by the company. While the design of the database may be owned by someone
else, the data is normally owned by the company/customer (unless this is some sort of "lookup" database you've
purchased, like a db to lookup zip codes or part numbers, etc).

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.

When you import, can you then view the tables? If you can view the tables after importing, you should be able to make
changes.

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.

In some instances, the app may be looking at your Windows login info and allowing/denying access based on that. If
that's the case, you should be able to look into the codebase and determine what's going on (or have someone do this for
you, if you're not confident about doing this).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Tony Toews [MVP]]

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/