locks in MS Access?

[Emo]

does anybody know how I would go around the locks on a database?

I want to edit a database but when I try to open it it says: "Could not open the locks" or something familiar to that...

If I copy/paste it in a different folder it works..so would that mean the restriction is from access or from Novell (that is on the server)

-Emo

[Beacon]

Dunno if you were in Access and you tried to edit something you couldnt it would say something like "Cannot locate row for editing" or "row is locked blah blah" or "Cannot open database for editing as it is open exclusively by user" or "Cannot open database for editing"

But it'd still open into access.
If it were Novell it would say it before you open Access.

The easiest way to test is copy the file in the same directory but with a different name then try it.
This should tell you if it's Directory Permissions or Access locks.

b

[Emo]

well I figuered it's both...

first it wont let me make any new files in that folder "Access is denied" ..then when I try to open the database from that folder it says:

"Could Not Lock File" and it's not loading it..

is it maybe because there is 2 files that folder and the second one has a little lock icon on it that locks the frist one??

-Emo

[swatty]

The little lock is because this is an mde file it is locked and can't be edited anymore.
No changes on the database can be made .

You should check for an mdb file which can be modified.

for updating, adding, editing records this works in both files.

[Emo]

Actually I just got it to work... it was the Novell privileges...

thanks a lot!

-Emo