Getting a (0x80004005) Unspecified error...but not always!!

I have a problem which is doing my head in. Basically I have 2 pages which use the same connection to open the database and an SQL statement to select records from 2 different tables. The code for the first page is as follows:

Set oConn = AdMentor_DBOpenConnection()
Set oRS = oConn.Execute("select farmid, name, description from bannerfarm")

This works fine and I'm able to retrieve the values from table 'bannerfarm'.

The code for the second page is as follows:

Set oConn = AdMentor_DBOpenConnection()
Set oRS = oConn.Execute("select zoneid, zonename, descr from zone")

It uses the same method to open a connection to the database and an SQL statement to get the records. However, on this page I'm getting the (0x80004005) Unspecified error and I can't work out why. I have tried the SQL statement directly within Access and it works fine, so why do I get this error within the ASP page??

Here is the code for the actual connection to the database:

g_Admentor_strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & request.servervariables("APPL_PHYSICAL_PATH") & "database\ad2000.mdb;Persist Security Info=False"

Function AdMentor_DBOpenConnection()
Dim oConn

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open g_AdMentor_strConnect
Set AdMentor_DBOpenConnection = oConn
End Function

I added a Response.Write(oConn.State) to both pages and on both pages the result was '1', so I'm presuming the connection to the database is being opened. If so, I'm even more preplexed cause it can only mean the problem is with the SQL statement!!

Has anyone got any idea what the problem is?

Ok....this gets even more strange by the minute.

After trying all sorts of things I converted the database to 97 format and changed the connection string to...

g_Admentor_strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("/database/ad2000.mdb")

.....and everything is now working fine!!