Interessant nok. Som nævnt er jeg stødt på det før, men opgivet at forstå løsningen. jeg scannede nettet igen og stødte på denne demo på
http://www.learnasp.com/learn/joust/http://www.learnasp.com/learn/test/dbtablepaged.asp?<html><head>
<TITLE>dbtablepaged.asp</TITLE>
</head><body bgcolor="#FFFFFF">
<!--#INCLUDE VIRTUAL="/ADOVBS.INC" -->
<%
connectme="DSN=Student;uid=student;pwd=magic"
sqltemp="select * from publishers"
' Troubleshooting TIP:
' if you use this code and get an error, for example:
'
' ADODB.Recordset error 800a0cb3
'
' The operation requested by the application is not
' supported by the provider.
'
' You may have a driver that is out of date, see:
'
http://www.learnasp.com/learn/connectioninfo.asp ' for code that will identify what your driver version is
' this script works with Access, SQLserver and Oracle
' with up-to-date drivers
Hans eksempel virker selvfølgelig på en SQL database, men hvad med Access
Hans Access drivere er:
Access Connection ConnectionADO Version: 2.1
DBMS Name: ACCESS
DBMS Version: 03.50.0000
OLE DB Version: 02.00
Provider Name: MSDASQL.DLL
Provider Version: 02.10.4202.0
Provider Friendly Name: Microsoft OLE DB Provider for ODBC Drivers
Driver Name: odbcjt32.dll
Driver Version: 04.00.4202
Driver ODBC Version: 03.51
Mine er:
Access Connection ConnectionADO Version: 2.1
DBMS Name: ACCESS
DBMS Version: 03.50.0000
OLE DB Version: 02.00
Provider Name: MSDASQL.DLL
Provider Version: 02.10.3711.0
Provider Friendly Name: Microsoft OLE DB Provider for ODBC Drivers
Driver Name: ODBCJT32.DLL
Driver Version: 04.00.3711
Driver ODBC Version: 03.51
Det ser ud til at hans versions af provider og driver er nyere (af en eller anden grund).
Har du mulighed for at checke din driver version. Som sagt har Scannet samme problem mht Access.
Henrik