Re: Unlock database



On Fri, 15 Jun 2007 15:18:00 -0700, 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.

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@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.



Relevant Pages

  • Re: Database design question
    ... > find more support. ... I have worked with a database which included this design, ... >> country lookup value, but this is not very likely... ...
    (microsoft.public.sqlserver.programming)
  • Re: LDAP Performance (long)
    ... Cache the slapd's internal database lookups in slapd memory. ... The first is the new TAG:key lookup, ...
    (comp.mail.sendmail)
  • RE: change field properties, reflect in query
    ... Another thing you could try is creating a new blank database and ... survey could get cranky;). ... I'm using lookup tables, validation ... it is likely you are doing something wrong with your database design. ...
    (microsoft.public.access.gettingstarted)
  • Re: Same database or another?
    ... that I have used the lookup wizard provided. ... if I choose to add tables to database that have absolutely no relation to ... >> work toward the capture of the feral animals. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Database design question
    ... The kind of design you are suggesting is going to ... to store information about networking devices that have wildly varying ... And if you are proposing to build a database where you define your database ... > country lookup value, but this is not very likely... ...
    (microsoft.public.sqlserver.programming)