Locked out

[Guest]

Over the last few years I've been compiling a db using Office 95, then 97 and
more recently finished it using 2000. My problem is this... I passed it to a
friend to "try out" to make sure it would work, but when he e-mailed it backI
couldn't get in. The error message I know get is ---

"you do not have the necessary permissions to access to use "file.mdb"
object. Have your system admin or the person who created the object establish
the appropriate permissions for you."

I created it, my friend tested it and neither of us have played with the
security settings. It may only be 10 meg in size, but it's 4 1/2 years
work.... any ideas how I can get round this?

Les.

 

[Rick B]

When you emailed it, you should still have the original file on your hard
drive. Can't you open that?

The one your friend sent you, did you save it to your harddrive and then
take away the "read-only" attribute if it was applied?

Rick B

 

[Guest]

Rick,

Like an idiot I picked up a virus and lost two thirds of my stuff - only a
couple of days before I do my usual back up. Unfortunately the original was
amongst the casualties.

The copy I had back I checked for the "read only". No joy. Luckily (I
thought) my friend burned a copy to disc. As usual the "read only" attribute
was in place. Copied this to my "post virus" PC, removed the read-only and
still nothing.

So now I'm trying to access ('scuse the pun) a 10 meg non-read only .mdb
file that's on my hard disk and getting now where fast. I fear I've lost a
few years work all due to a virus

Les.

 

[Rick B]

Lynn: Is this a security-related issue? You are the expert!!

Rick B

 

[Joan Wild]

Over the last few years I've been compiling a db using Office 95,
then 97 and more recently finished it using 2000. My problem is
this... I passed it to a friend to "try out" to make sure it would
work, but when he e-mailed it backI couldn't get in.

Was he able to get in OK?

The error
message I know get is ---
"you do not have the necessary permissions to access to use "file.mdb"
object. Have your system admin or the person who created the object
establish the appropriate permissions for you."

I created it, my friend tested it and neither of us have played with
the security settings.

I suspect that he did play with security.

Anyway, try opening Access and creating a new database. Import all objects
from yours.

I seriously doubt you've lost your work, so post back if this doesn't work.

 

[Guest]

Joan,

Just had a go and I can't get passed the message, no matter what I try.

Les.

 

[Joan Wild]

Joan,

Just had a go and I can't get passed the message, no matter what I
try.

You friend must have secured it. Ask him to search his computer for *.mdw
files and send you the necessary file. He'll also need to supply a
username/password.

Are you getting the login prompt for any mdb you open, or just this one?

 

[Guest]

I've spoken to my friend and he doesn't remember playing around with
anything, but I've asked him to check for the .mdw file. The only thing I get
when trying to open the db is the error message - no sign of a log
in/passward screen.

Thanks for trying.

Les.

 

[Lynn Trapp]

It sounds a lot like it is. Joan W., my "expert" friend, is working with him
on it and will, no doubt, help him get it all sorted out.

 

[Joan Wild]

OK, we'll back up a bit. You said your friend tested it, and sent it back.
Can he still get into his copy OK? (and why did he send it back - didn't
you have the original still?). If he can get in OK, have him resend it to
you.

 

[Joan Wild]

Here's another thought...
Do you still have the email you sent him (with the original mdb attached)?

 

[Guest]

Joan,

I've spoken to him again... he's tried the copy he holds and he can't get in
either - so it's something he's done.

He sent me back a copy after I lost most of my stuff after the virus hit me
- I also lost all e-mails, address book entries.... the lot.

I've still got all of the info on paper, so I think I'll have to sit down
quiet and re-do the lot... probably the easiest option, rather than pay for a
password/access cracking type prog which might not work.... I've looked but
haven't seen any, but I've been advised by a colleague at work that they are
out there.

Les.

 

[Brendan Reynolds]

Hang on though - if you don't have your copy of the e-mail, does your friend
still have his copy, with the attached MDB? The attachment should be as you
sent it, before he made any changes.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Guest]

Brendan - great minds think alike!

Unfortunately the idiot (if I can call him that) deletes his read e-mails
once he's saved any attachments. So all he has is the "modified" version.

Les.

 

[Joan Wild]

Brendan - great minds think alike!

Unfortunately the idiot (if I can call him that) deletes his read
e-mails once he's saved any attachments. So all he has is the
"modified" version.

Well if he's truly an 'idiot' (and no it isn't likely true nor nice to use
that term), it's likely that the message is still in his 'deleted items'
folder.

Anyway, I don't know what 4 years of work is worth to you, but there are
tools you can find on the internet to break into an Access database.

If anything, I hope you've learned how important backups are.

Been there, done that, had to redo the work because of it!!