[AccessD] Access and ASP problem

Pete Phillipps accessd at vftt.co.uk
Fri Mar 2 11:44:21 CST 2007


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
 



More information about the AccessD mailing list