Hi all

I normally use ASP with non-parametised SQL Server procedures like this:
Set AdoCommand =3D Server.CreateObject("ADODB.Command")
Set AdoCommand.ActiveConnection =3D Session("Conn")
Set OccRS =3D Server.CreateObject("ADODB.RecordSet")
DatabaseOccur =3D "A_qOccurrences"
AdoCommand.CommandText=3DDatabaseOccur
OccRS.MaxRecords =3D 300
OccRS.open AdoCommand

I have tried to use the same sort of code whilst connecting to an Access =
database with a non-parametised query.  However, I receive the following =
error:
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', =
'SELECT', or 'UPDATE'.

Can anyone help with me with the SQL statement I need to pass to Access. =
 Sorry if this is a dumb question - I've never really used Access =
before.

Thanks in advance
  =20
_____________
Andrew Browne
IT
658-6484        =20
_____________

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA