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...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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.
Dig Deeper on Windows File Management
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Windows Server experts
View all Windows Server questions and answers
Start the conversation
0 comments