Hi,
 Please help me out.I am getting errors such as 
  Operation must use an updateable query
  Database or object is read only etc.
 when i try to update or insert to the database. However all my select 
queries work just fine.
 
 My ISP says they have set proper permissions to the folder containing my 
db & there is nothing they can do on their part.The problem is that it 
works just fine in my IIS & also on a different host.What do you think 
might have gone wrong?

 I have used a connection string which is stored in a session variable 
which has been assigned the value in global.asa file.I have tried with all 
types of cursor & locking types I still get the same errors.
 
 Your early response is greatly appreciated.Thanking you for all those 
GURUS in advance.

rgds,
 prithvi
 
 

Try using the FileSystem object to create and delete a file in the same 
folder.

It could also be a connection string problem with the path to the file.  
Check the connection string value just before you open the database to 
make sure it's what you're expecting.

Shawn

> Hi,
 > Please help me out.I am getting errors such as 
 >  Operation must use an updateable query
 >  Database or object is read only etc.
 > when i try to update or insert to the database. However all my select 
q> ueries work just fine.
 > 
 > My ISP says they have set proper permissions to the folder containing 
my 
d> b & there is nothing they can do on their part.The problem is that it 
w> orks just fine in my IIS & also on a different host.What do you think 
m> ight have gone wrong?

>  I have used a connection string which is stored in a session variable 
w> hich has been assigned the value in global.asa file.I have tried with 
all 
t> ypes of cursor & locking types I still get the same errors.
 > 
 > Your early response is greatly appreciated.Thanking you for all those 
G> URUS in advance.

> rgds,
 > prithvi
 > 
 

Hi Shawn,
  When i try to use filesystemobject I get this errror


Microsoft VBScript runtime error '800a0046' 

Permission denied 

/shop/createexcel.asp, line 31 


where line 31 is the line below.Can give me exact details on what my ISP 
has to do?

 Set fso = Server.Createobject("scripting.filesystemobject")

rgds,
 prithvi

Hi Shawn,
  I tried to use filesystemobject & I get this errror


Microsoft VBScript runtime error '800a0046' 

Permission denied 

/shop/createexcel.asp, line 31 


where line 31 is the line below.Can give me exact details on what my ISP 
has to do?

 Set fso = Server.Createobject("scripting.filesystemobject")

rgds,
 prithvi

Sounds to me like there's still a permissions problem.  The IUSR_<machine 
name> user needs write access to the directory when using Access databases 
so that the lock file (*.ldb) can be created.

Shawn 

> Hi Shawn,
 >  When i try to use filesystemobject I get this errror

> 
M> icrosoft VBScript runtime error '800a0046' 

> Permission denied 

> /shop/createexcel.asp, line 31 

> 
w> here line 31 is the line below.Can give me exact details on what my ISP 
h> as to do?

>  Set fso = Server.Createobject("scripting.filesystemobject")

You need to have write access within the directory.  Your ISP should have 
instructions on how to change directory access attributes.

Raymond



> Hi,
 > Please help me out.I am getting errors such as 
 >  Operation must use an updateable query
 >  Database or object is read only etc.
 > when i try to update or insert to the database. However all my select 
q> ueries work just fine.
 > 
 > My ISP says they have set proper permissions to the folder containing 
my 
d> b & there is nothing they can do on their part.The problem is that it 
w> orks just fine in my IIS & also on a different host.What do you think 
m> ight have gone wrong?

>  I have used a connection string which is stored in a session variable 
w> hich has been assigned the value in global.asa file.I have tried with 
all 
t> ypes of cursor & locking types I still get the same errors.
 > 
 > Your early response is greatly appreciated.Thanking you for all those 
G> URUS in advance.

> rgds,
 > prithvi
 >