Q

Cannot access .mdb file from client

I have created on ActiveX Control to put it on to Web. I am using a mdb (MS Access file). I am able to access the database through the front end of the server, but when I package and deploy it on the client, I am not able to access the server (i.e the .mdb file). Please help me. The following is the database module:

This is the code to open the database in the module:

Option Explicit
Public db As Connection
Public Prs As Recordset

Public Sub OpenDatabase()
    Set db = New Connection
    db.CursorLocation = adUseClient
    'db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data
Source=IPADDRESSwwwpagesbin2250.mdb" '
this is my server IP address

    'db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data
Source=d:naldisplay2250bin2250.mdb" ' this is
where it is loaded on my harddisk

     db.Open "nal3000"        'this is my userDSN Name

    'db.Open
"d:/inetpub/wwwroot/dark.com/www/pages/Bin2250.mdb"
 'this is where the file is loaded on the server
    End Sub

There are many different things that could be wrong. Your best bet would be to attempt to access the database from a normal client application. In other words, make a simple form-based application and try to make the connection to the database. That way you can find out the problem in an isolated case instead of something running inside IE.
This was first published in June 2002

Dig deeper on Windows File Management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close