Search results for query: *

fanks Mate, too late though, I created a between in the where clause instead, using some Tasty VBscript to get the first and last days of that particular month. I always solve my problems by looking at them from a different angle! Oh and the design of TblStats, that was given to me in an...

I need (in my SQL) to select records from my Access DB where a paticular Month matches the one in the Date field. So I pull out all records for one paticular month. I tryed:(September select example) "SELECT * FROM tblStats ORDER BY Date WHERE Date=#10/%/%#" But this doesn't work...

Im running IIS 4 on an NT machine, My code is VBscript, Is it possible to do this? Some input would be great, thanks Colzo

Yes,checked that, it worked with a ODBC connection string, this problem is caused by the JET... It's accessing an Access 2000 DB, has anyone else got any ideas?

I've just changed to Jet to connect to my DB, im running a NT 4 server with IIS 1 or 2 I think. I've dealt with a lot of errors in the past, however this one mystifies me " error '80004005' Unspecified error " nice one Microsoft. It refers to the line after the last line in an include...

Now I get Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /wwwroot/employers/submit.asp, line 91 Instead.... Great....

The error I get exactly is: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /wwwroot/employers/submit.asp, line 90

Im using Access2000 UltraDev...Sorry And it works fine inserting elsewhere... This meesage has come up before for, me. It is when I am Inserting a new record, and there is a many-to-one relational numeric field in there. It pulls up the Column Header type mismatch error, yet my headers are all...

I have a cute little page that Pulls stories from a DB, and well, its uses a querystring to pull certain ID numbered records from the DB. I didn't use the POST method, as I wanted to be able to link to the news page with a specific story in mind. Well, I can only pass a query string to just the...