Accessing MDB with ASP: The specified module could not be found.



I am using Julitta Korol's "Access 2003" book (Wordware). So far it's been
great. However, I'm now trying to go through the Access and Access Server
Pages sections, and am having problems with one of the first exercises.

After copying the files from wordware (and typo checked by me), I have the
following GetCustomer.asp file

<%@ Language=VBScript %>
<TITLE>Retrieving a Recordset</TITLE>

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & _
Set rst = conn.Execute("SELECT CompanyName FROM Customers")
Do While Not rst.EOF
Response.Write rst("CompanyName") & "<BR>"

When I try to run it in my browser with

I get an error page:
The specified module could not be found

I have checked that the northwind.mdb is in the correct directory, that the
virtual directory is correctly set (I can see the asp file in the directory
list using http://localhost/

I have tried several different Jet driver / provider instructions to no avail.

I'm running Access 2003 on Windows XP with all the latest updates. Looking
at the source code of the error page doesn't give me any clue as to which
module can't be found.

I don't know if it makes a difference, but I've made sure that ADO and ADOX
are referenced in the northwind.mdb code.

This may be an ASP forum question, but I'm hoping someone here has a clue
about this.



I feel stupid for not trying it first, but I don't get the problem with IE,
only with Firefox. Any thoughts as to why and how to fix it?


In case I'm not the only idiot - I just discovered that Firefox doesn't
support vbscript. Oops.

David W. Fenton

In case I'm not the only idiot - I just discovered that Firefox
doesn't support vbscript. Oops.

Nor does any browser except IE, which is why one should never use
VBScript client-side.

But I didn't see any client-side VBScript in your ASP code, so that
really oughtn't be the problem.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question