[thelist] SQL & ASP my favorite combination :-)

[Don Makoviney]

A little more info taken from:

http://www.learnasp.com/learn/faqdbupdate.asp

This is a very common error message when updating Access databases. Since
Access is file based any attempt to update the database by an ASP script can
only modify the Access databases if permissions are established correctly.

Go to the parent directory where the database is stored. Click on the folder
permissions and set IUSER_xxxxx to 'change' where xxxxx is the machine name.
Make sure the file is also set so the ISUSER_xxxx can change the file.

http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
shows some other causes besides permissions.

HTH,

DM

-----Original Message-----
From: Don Makoviney [mailto:DonM at allensysgroup.com]
Sent: Wednesday, May 09, 2001 11:51 AM
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] SQL & ASP my favorite combination :-)


You need to make sure that the directory the DB is in has write permissions.

DM

-----Original Message-----
From: Elfur Logadóttir [mailto:elfur at lists.evolt.org]
Sent: Wednesday, May 09, 2001 11:48 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] SQL & ASP my favorite combination :-)


From: "Scott Dexter" <sgd at ti3.com>

| don't use the Command object to run the code, use the Connection object
| instead:
| 
| objConn.Execute strsql
| 
| and fergit the Command object altogether on this one; ya don't need it =)

thanks scott, but that did nothing for me ... 
still the same error

elfur.is


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !