473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access remote access database from ASP

Hi,

I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:\Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:\' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.

Could anyone tell me how to make it work?

Thanks.
william
wc**@mfgsyscorp.com
Jul 19 '05 #1
5 2842
On Tue, 10 Feb 2004 11:41:06 -0800, "william"
<an*******@discussions.microsoft.com> wrote:
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:\Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:\' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.

Could anyone tell me how to make it work?


Proper permissions would likely do it. keep in mind that an ASP page
isn't running under the same account you mapped the drive with. It's
normally the IUSR account that needs the right permissions, and that
account is a local account, not a domain one.

Jeff
Jul 19 '05 #2
Hi Jeff
Thanks
Could you give me some steps to make it

willia
Jul 19 '05 #3
Hi
I created IUSER_SERVERNAME on Domain with empty password, and grant this user full control permission on the folder where my access database locates on other machine, and I'm able to run my ASP to access the remote database, but when I try to run second time I got "Unspecified error" error( when the asp show up, it will go to remote database to get some data back and populate list box on the asp page, there is button on the page, on click event, it will query the database again)
I use a DSN to access database

Any idea

Thanks

willia
Jul 19 '05 #4
Hi
Can I use domain user id to access remote Access2000 database
I created IUSER_SERVERNAME on PDC with password, grant this user full permission on the remote database folder, and setup to use this account on IIS\Properties\Directory Security\Edit\Annonimous Access\Edit, and uncheck the check box(allow IIS to control password). I got "...-[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

Any ideas

Thanks

william
Jul 19 '05 #5
Hi
From Event view, the error is "The server was unable to logon the Windows NT account 'IUSER_C2K-WHAM' due to the following error: Logon failure: unknown user name or bad password. The data is the error code.

thank
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: kackson | last post by:
Hi. I would like to access my database outside of my company. I read many documents but they are all pertaining to accessing the database via ASP or some form of web application. Is there no...
4
by: Peter Larsson | last post by:
Hello everybody, I'm developing a system for a company that has production at two different locations. The production is stored in an Access database at each location, and I need to find a way...
5
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops....
9
by: Tony Lee | last post by:
Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
2
by: James | last post by:
Dear Access Guru's, Hopefully you can help me (as Microsoft don't seem to be able to) We have an Access database on a Windows 2003 server with 5 CALS in our office. Access is loaded onto...
3
by: Lyle Fairfield | last post by:
In a recent thread there has been discussion about Data Access Pages. It has been suggested that they are not permitted on many or most secure sites. Perhaps, that it is so, although I know of no...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
13
by: Bob Palank | last post by:
Remote server hosts a .mdb file but the client cannot access the DB through VB.Net Express 2005. My Assumptions: 1. One can use VB.Net Express 2005 to write a client resident application to...
7
by: =?Utf-8?B?a21jY29za2V5?= | last post by:
I'm trying to access an access database on the file server from a web server using asp.net and IIS 6.0. I can do it when I have anonymous access enabled in IIS 6.0 as in the public internet web...
0
by: Nymus | last post by:
I would like to use an access database as a shared database on a remote website. I don't know if it is possible, but this is what i would like to do with this database: - Use it to run a database...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.