Exclusive Lock Error

[bcw]

I have a 3 user database running on a Novell network. 2 system are running Win2000 and the other Win98. The database resides entirely on the server (not split at all).

I've created a report writer that opens a new report in design mode and saves the report. I recently learned that you can't create a report unless you have exclusive rights to the database. (This isn't my main problem but if anyone knows how to work around it, please let me know. Access is a waste if I can't have users create their own reports without booting everyone else out) Anyway, both users on the Win2000 machines can create reports with no problem if noone else is in the database. The Win98 user get's the "You do not have exclusive rights to the database....error" even though nobody else has opened the database.

I've checked to make sure their isn't an .ldb file before they open the database. Since nobody else is logged in it can't be opened exclusively by someone else.

The user can open all forms and change records but just can't create new reports. Am I missing something? Is there an option that must be set on the Novell permissions (I'm pretty sure all users are the same)? I've logged into the machine using the network password of an account that works on the 2000 machine and I get the same error.

Any suggestions would be appreciated. Thanks.

Brian

 

[JimHorton]

Brian,
I've never heard of such a thing--needing exclusive access to create a report. I just tried to make sure it wasn't one of those things that I've never run across, but I'm here VNCing into 3 machines, opening the same db on one of them, and each machine I can create and save a report. I even created several at the same time--each was tentatively titled (in design view, before saving) Report1, and as I saved the second & third ones, I just got the "report1 already exists, overwrite?" message. But I could rename and save just fine.

All I can say is that it could be an access security issue or a novell file-permission issue. The latter could easily be checked by seeing if you can create *any* object (whcih would require Novell rights to alter the .mdb file). If it's just reports that you can't create, but you can create forms, etc, then it must be an Access thing. But there is nothing that I know of in Access that says an .mdb must be open exclusively to create a report.

From my work PC, a Win 2000 machine, I get "You don't have rights to the folder nnnnn" when I try to re-attach linked files with the Linked Table add-in, but it lets me go ahead and do it anyway. Goofy. So I'm not sure what the problem there is, but Access has no such restriction on reports.
--Jim

 

[bcw]

Thanks for the reply Jim.

What version of Access are you running? I'm on 2000 and I found on the MS website yesterday that it's new in 2000 that you have to have exclusive rights to create an object(report, form...) It stated that it trys to promote your lock to exclusive but I couldn't find any detail on how it works or why it doesn't work on mine (found searching the ms knowledge base for "lock promotion&quot.

As far as Novell goes I can create other documents in the folder so I guess Novell isn't the issue. It does have Access security on it but I find it strange that a user can log on at one machine and have it work but it fails on the other.

I guess I'll try to get rid of the security and see if that helps.

Thanks for the response.

-Brian

 

[JimHorton]

Brian,
I'm using A-97. I wasn't aware of this issue in a2k. I tried a2k quite some time ago, and (there've been several threads about this) I found so much bizzare corruption and scads of insidious bugs that I never went back. This report-design issue is a new one on me, I don't understand such an elementary functionality would be yanked from the app.
--Jim