Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 27th, 2003, 08:13 AM
Registered User
Join Date: Aug 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database is located on a network drive


Pls advise how to connect to Access database located on a network drive. The network drive operation system is Window NT 4.0 server. I used the the following code to perform the connection but was unsuccessful.

    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=\\myServer\myShare\myPath\myDb.mdb"

The browser show

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

Thank You.

Old August 27th, 2003, 08:32 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post

Its most likely a permissions issue. Is your page running as the anonymous user (IUSR_MachineName)? If so then you'll have no luck because that's a local account not a network account, so it won't have rights to any files on the network. Stick with anon, but either:
1. change the anon user to a network account that has permissions to that network share and re-try.
2. create a local account on the network PC with the same name and password as your anon user and give it rights to log-on locally to that PC (often us lowly developers don't have rights to do that sort of thing :)

If your page isn't running as the anon user then you'll not have any luck either because of NT's lack of delegation - switch back to anon and follow the advice above and you should be OK.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing network drive on a web part Indo77 ASP.NET 2.0 Basics 0 July 5th, 2007 08:14 AM
Publishing a page on network drive Sicklr Access 1 June 21st, 2007 12:35 AM
How to run app from network drive? nasimg VB.NET 1 January 25th, 2007 12:42 PM
How to backup database to Network Drive Jane SQL Server 2000 3 July 4th, 2005 12:37 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.