I.T. Discussion Community!
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyASP Classic Coding BoardASP Classic - Handling Data Topic   Print This     

Remote Access Database

Remote Access Database in ASP Classic - Handling Data topic (part of our ASP Classic Coding group).

Quick Search: Database   Remote Access   Remote Access Database  
John Anderson
Jones & Stokes
 (Inactive)
Sacramento
I have read every knowledge base article Microsoft has written on the subject of connecting to a remote Access database from an Active Server Page and have done everything the articles say to do and still come up with the error:

The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.

I know the file is not open, so that leaves permissions as being the cause. I've given every account in the f***ing domain full control of the share and file on the file server and still no dice.

Who is making the call from the web server to the file server? Can somebody tell me that?

My web server is Win 2k running IIS 5 and the remote Access database is on a Win 2k server that is a domain controller.

Any light anybody can shed on this would be most
appreciated.
 Posted 17 years ago (Thread Starter)
Comment Quote
About John Anderson -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #10019, 2 replies
Thread Started 11/10/2003 10:25:00 AM
View Counter=3625
Last Reply Posted 1/20/2004 5:36:00 AM)
Location=Sacramento  
Joined=17 years ago   MB Posts=1  
cheddar
Lodi, CA
Are you using anonymous access, if so turn it off and use intergrated instead, this way you will execute with the rights of the person who logs in
Eric Neff
C#, ASP.Net, SQL Server, Oracle
 Posted 16 years ago
Comment Quote
About cheddar -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #10168 (Level 1.1)  Reply to 10019
Thread Started 1/12/2004 12:35:00 PM
View Counter=2
Location=Lodi, CA  
Joined=19 years ago   MB Posts=88  
Most Recent Post
Sandman
 (Inactive)
Northern Ca.
It maynot hurt to run this too:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/locktool.asp

Also run a complete virus check.

Think "Code Red" and alike, any of them that use "IIS".

I though I had a clean system ... but still found afew of these that use "IIS". Eek!
 Posted 16 years ago
Comment Quote
About Sandman -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #10256 (Level 1.2)  Reply to 10019
Reply Posted 1/20/2004 5:36:00 AM
Location=Northern Ca.  
Joined=18 years ago   MB Posts=23  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1246A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #10019 Counter
3625
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech