[AccessD] Access and ASP problem

Check your folder permissions.  That is the usual problem. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pete Phillipps
Sent: Friday, March 02, 2007 9: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