Unlocking a file?

[Muglerienne]

Hi,

I was wondering if there's a way to remove the security that a third party designer has added to a file. Is there an easy way to do this at all? Or is it really necessary to contact the original designer?

Thanks everyone!

 

[reclusivemonkey]

Bit vague; any more details?

 

[Muglerienne]

Bit vague; any more details?

Em, I'll do my best, but it's for someone at my head office, and I haven't actually seen the file she's talking about. However, as far as I know, she is attempting to create a new query on a file, but she says it is locked, and doesn't have the option to create a new query, just to use the reports the original designer created in the first place. What she needs is to be able to manipulate the information in whatever way she needs, but as yet is having trouble getting in contact with the guy who created the database for her.

I don't know anything about Access, being an Excel girl myself, so am stuck!

Thanks again!!!

 

[reclusivemonkey]

Em, I'll do my best, but it's for someone at my head office, and I haven't actually seen the file she's talking about. However, as far as I know, she is attempting to create a new query on a file, but she says it is locked, and doesn't have the option to create a new query, just to use the reports the original designer created in the first place. What she needs is to be able to manipulate the information in whatever way she needs, but as yet is having trouble getting in contact with the guy who created the database for her.

Ah, I see. I wasn't sure initially whether or not it was an Access database. What is the extension on the database; is it a mdb file? I don't have much experience with securing Access, I mostly use it in a single user environment.

 

[Muglerienne]

Ah, I see. I wasn't sure initially whether or not it was an Access database. What is the extension on the database; is it a mdb file? I don't have much experience with securing Access, I mostly use it in a single user environment.

It is indeed a .mdb file.

 

[reclusivemonkey]

It is indeed a .mdb file.

At least that is a full file. Is the database window available when you open the DB? If not try holding down the SHIFT key while opening. If the "Database Utilities" menu is available then you can try converting it to another version, then convert back. Other than that I am not really sure. Sorry I can't be of more help. The Author of the DB is of course your best bet!

 

[ghudson]

FYI. You can conert a MDB to MDE [compiled version] and then rename the MDE back to a MDB so that it looks like a MDB file but it really is a MDE file. A trick I have used before. The files icon when viewed within Windows Explorer will show a lock on it if it is a MDE file. If it is a MDE [compiled] db then you will not be able to modify the db objects.