Solved

ActiveX dll object for asp use problem

Posted on 2002-03-14
3
147 Views
Last Modified: 2010-05-02
Dear All,
I had wrote a dll which will generate xml in a xxx.asp file (using msaccess xxx.mdb file). However, when the database file is located in a network driver it fail to open it. The encode is:

Sub xxx()
...
Set dbConnection = New ADODB.Connection
dbConnection.Open Application("wsr_db_ConnectionString")
...

End Sub

Application("wsr_db_ConnectionString") = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=S:\abc.mdb;" & _
  "Persist Security Info=False"


The error message is :
Error Occur in gm0101.gx0101() : -2147467259:The Microsoft Jet database engine cannot open the file 'S:\eSales.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

The IIS PC's OS is win2k pro and the network driver is a win98 pc. Both PC's file system are FAT32

I don't know why it claim that it is access control issue?

Thanks for the one who can help me!

Jeff Ching



0
Comment
Question by:jeff_ching
3 Comments
 
LVL 6

Accepted Solution

by:
Triskelion earned 100 total points
Comment Utility
Try using the UNC name and not the drive letter.

\\SERVER\directory\abc.mdb

Are you sure the drive letter is accessible to others from the web page?
0
 
LVL 49

Expert Comment

by:DanRollins
Comment Utility
Hi jeff_ching,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept Triskelion's comment(s) as an answer.

jeff_ching, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:kodiakbear
Comment Utility
Moving to the paq

kb
Experts Exchange Moderator
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now