Locked or broken?

  • Thread starter Thread starter Russ Lamb
  • Start date Start date
R

Russ Lamb

We had a disgruntled employee leave. It appears he may have done something
to the Access Database. He changed passwords but I was able to find one user
account. But I do not have "permission" to import data from this database.
You know the "ask your administrator for help". He claims no wrong doing
yada,yada,yada.... Long story short I have a user name and password ,not
admin level, but get the following message when it is loading the database
"Table "test1" was not found in database" "Could not refresh links". All
that remains is the Access program running. Our one Access,vb guru is gone
and the other techs only know sql and db2. I am intermediate at Access and
have no clue about vb. Is there any way to retrieve the data? Also does this
sound like a broken database or a deliberate sabotage case. I have tried to
run compact repair but I do not have the "permissions" to do this. Please I
have wasted about 15 hours of family time,no overtime pay, trying to work on
this at home to no avail. Hopefully one of you can walk me through this as I
prefer to learn from these life lessons. I am very eager to learn so any
help on this would be greatly appreciated.

Exhaustedly, Russ
 
If the database has a split "front end/back end" structure, & you have taken
it home, you might be using it from different folder names. Consequently,
the front end database might not be able to find the back end one - hence
"could not refresh links".

HTH,
TC
 
The system is a mde file. Access 2000. If I can't get in then how do i find
the backend tables. Is there a way to keep the database from trying to
refresh or search for the tables? It would seem that it is searching for
some kind of dummy or security table and that is what is preventing me from
being able to open from a non admin security level.
 
MDE does not mean (or not mean) FE/BE. So I'm still not clear whether it is
a FE/BE structure, or not. If the system has *two* files (MDE, MDB or a
mixture), it is probably a FE/BE structure - so the folder location of each
file would be significant. If it only has *one* file (MDE or MDB), it is
probably not a FE/BE structure, so the folder location of that file is
probably not significant.

Do you get exactly the same error on the home version, as on the work
version?

TC
 
Back
Top