"It is already opened exclusively by another user, or you need permission to view its data."

Greetings,

I have an ASP(on W2K) with runs a searching query through a remote Access 2000 database. This Access database is on a Novell Netware 5.0 server. I have installed the GSNW on my W2K server and created an account on Novell server. I used this account on GSNW to make the connection. I am able to map the database on my IIS server. I can open the database on the W2K without any problem. But when I ran my ASP, I got the following error msg"It is already opened exclusively by another user, or you need permission to view its data." I am sure the database is not open by anyone.

Also, I followed the following MS document.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q271/2/28.ASP&NoWebContent=1

Please Help!


M.
mrongAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thunderchickenCommented:
1. Make sure you close all your connections
2. Make sure Access isn't open
3. Make sure you have permission
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mrongAuthor Commented:
What do you mean by "close all your connection"?

0
thunderchickenCommented:
cn.close
set cn = Nothing

Anytime you access the db from access
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

thunderchickenCommented:
ar,

Anytime you access the db from ASP
0
mrongAuthor Commented:
Here is my connection:

Set objConn = Server.CreateObject("ADODB.Connection")objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source=Z:\MTrackBE.mdb;Persist Security Info=False;"

Yes, I checked all 3 already.

.
0
BubbaisBestCommented:
mrong,

I have had this happen a couple of times on me.  All I did was went to the database server itself, made a copy of the database, deleted the old database, renamed the copy of the database to the original name and then it works.  Not sure if it was that I didn't get a connection closed or something else funky but it doesn't happen very often to me.

Good luck,
Bubs
0
nishikanthCommented:
pls give user permissions on ther server

or try this

right click the guest account you added and make sure that it has access to the database you are trying to use. You can provide access by checking the box next to the list of the databases.
0
mrongAuthor Commented:
I have it fixed. My Novell Administrator didn't set up the right password for IUSR_HOST user.

Thanks:-)

M.
0
thunderchickenCommented:
> 3. Make sure you have permission
0
thunderchickenCommented:
Why close this? There were already correct answers given.
0
BubbaisBestCommented:
Thunderchicken should receive the points due to his #3 in his post and even later in the post mrong stated that this had already been checked and was correct.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.