Access 2000 Issue

[BlackS2]

Hi,

We have a few users that all work on one database and a couple of these users are getting issues when trying to open querys on the database while others can get in fine.

The actual error that they are getting is: "The Microsoft Jet database engine cannot open the file Filename. It is already opened exclusively by another user, or you need permission to view its data."

I have had a search on microsoft's support pages and found this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;815142&Product=acc2000

which would seem this is a fix or patch that is needed to be installed to cure this problem. As per the thread they all have Office 2k SP3 installed and are all running Win2k SP4.

My question is, can it be fixed any other way? It is quiet an urgent problem that I really need to solve today. Has anyone else encountered this before or can you offer any advice?

All suggestions greatfully recieved!

Thanks.

 

[tviman]

Well, the key here is this:

This problem may occur when you are also using any of the Windows Accessibility Options.

I any of your users have these options turned on, then I suspect that you're going to have this problem. Another thing to think about, and I'm not 100% certain of this, but I seem to remember that some versions/configuations of Access are limited to 5 concurrent users. May be something to check into.

There's always a better way. The fun is trying to find it!

 

[bjzielinski]

I created a database for 3 people and sometimes see this error if I want to edit a form or table when they have something exclusively locked. On each form you can set how the records are locked. Look at the Form properties and check the values for Recordset type and Record Locks. If they are editing data directly you need to lock only the current record, unless it affects other records. For displaying data, you may only want a snapshot. Try different values in each field, each scenario requires different combinations. For what it's worth, some of my forms that may be open on different computers say Dynaset (Inconsistent Updates) and No Locks, and they do not experience any problems unless they update the same record, which rarely if ever occurs.

Bill Zielinski
bzielinski@co.midland.mi.us
County of Midland, Michigan

 

[BlackS2]

Thanks for your reply's guy's but I feel that the accessability options is not what is the problem, no one here uses these and there are 3 people that can get into the database and about 4 that can get in but then get the error when trying to open a query. I know that the security settings have not changed on the database so that should not be an issue.

I have also been in contact with Microsoft and they have supplied me the patch in question regarding the link above and I have applied it to one machine that was having the problem and it did not change a thing! after 2 reeboots still the same error.... so back to the drawing board....

 

[autosol]

Just to let you know, I have just encountered the same error with a db that has been working just fine for quite awhile. The only thing that has changed is that I installed Office SP3 the other day to solve another problem. Now I can't link to the backend db file using the Linked Table Manager. At first I was encouraged that MS had a fix but then read on and found it didn't work.

Anything new on this issue?

 

[BlackS2]

Autosol - Sorry, I should have updated this! Well all my hard work and running about was not needed after all as the database administrator had ran some query's the day before but set only selected permissions to the database admins in the group (they did not realise they had done this) after they went in and changed the permissions their end all was fine once again.

Cheers.