[AccessD] Access and ASP problem

Drew Wutka DWUTKA at Marlow.com
Fri Mar 2 12:19:41 CST 2007


I've never used constants in ASP, try replacing them with their numeric
values.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pete
Phillipps
Sent: Friday, March 02, 2007 11:44 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access and ASP problem

Hi Everyone,

	I have an Access database on my web site and IIS installed on
both
my desktop and laptop for testing changes to it.
	I have an ASP file that should add a new record to one of the
tables; a snippet is shown below:

	strSQL = "SELECT TOP 1 * FROM tblAttendees"
	Set rsPlayerTourneyRS = Server.CreateObject("ADODB.Recordset")
	rsPlayerTourneyRS.CursorLocation = adUseServer
	rsPlayerTourneyRS.Open strSQL, dbConn, adOpenKeyset,
adLockOptimistic
	rsPlayerTourneyRS.AddNew

	On my desktop machine, and the web site, the code works, but on
the
laptop the .AddNew method gives me the following error message:
	Current Recordset does not support updating. This may be a
limitation of the provider, or of the selected locktype.

	If I use rsPlayerTourneyRS.MoveLast, I get the following error
message:
	Microsoft JET Database Engine (0x80040E24)
	Rowset does not support fetching backward.

	Both machines are running Windows XP with SP2, Office 2003, IIS
is
configured the same on them.

	Does anyone have any idea why it is not working on the laptop?

Pete

"Many [wargame] battles have been fought and won by soldiers nourished
on
beer" - Frederick the Great, 1777
Download VIEW FROM THE TRENCHES (Britain's Premier ASL Journal) free
from
http://www.vftt.co.uk
Get the latest news about HEROES(ASL in Blackpool) at
http://www.vftt.co.uk/heroesdetails.asp
Get the latest news about INTENSIVE FIRE (Britain's biggest ASL
tournament)
at http://www.vftt.co.uk/ifdetails.asp
Get the latest UK ASL Tournament news at http://www.asltourneys.co.uk
Support the best at http://www.manutd.com/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.5/707 - Release Date:
01/03/2007
14:43
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list