[AccessD] Access and ASP problem

Hi Everyone,

	Doug Murphy wrote:
	<<Check your folder permissions.  That is the usual problem.>>

	Eric Barro wrote:
	<<Specifically you need to give the IUSR_MACHINENAME account read,
write, modify access to the file since Access wants to create an LDB file to
lock the file while updates are going on.
	When you browse a page the account that is being used is the
IUSR_MACHINENAME account where MACHINENAME is of course your machine name
when you set up your OS.>>
	In IIS on both machines, the virtual directory has Write permission
enabled. Haven't checked every setting in IIS, but the ones I've looked at
are the same on both machines.
	I gave the IUSR_MACHINENAME account write permission on the folder
in Explorer but it didn't make any difference. On the desktop though the
IUSR_MACHINENAME account is not shown in the list of users with permissions
on the folder yet the ASP file runs fine.

	Drew Wutka wrote:
	<<I've never used constants in ASP, try replacing them with their
numeric values.>>
	Didn't make a difference :-( 

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/


-----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?


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.6/708 - Release Date: 02/03/2007
16:19