I am using an Access database which consists of only 2 columns.

I have written some sql which accesses the database and checks to see if 

the code that was submitted on the asp page is in the database and also 

checks to see if the second column (Company Name)Value is 'NoName'.



If the code is in the database and the other column contains the value 

'NoName' then the column containing the value 'NoName' should be updated to 

whatever the value for Company Name on the asp page was given as.



This worked fine on my development machine.  However when I uploaded it to 

the server it dosen't.



If I enter an invalid code it does what it is supposed to do and returns a 

message saying 'Invalid Code'.  However when I enter a valid code it gives 

me the following error 'Access Error: must be an updateable query'



I have checked MSDN and found various things like make sure the DB file is 

writeable etc. but to no avail.



I know the paths i am using to the database are correct because I've used 

Server.Mappath.



Any ideas?  Would be greatly appreciated!



Thank



Alan

You might be getting the error for lots of reasons - you don't have

permission to change the database, your UPDATE query syntax is malformed...



Cheers

Ken

----- Original Message -----

From: "ALAN" 

To: "ASP Databases" <asp_databases@p...>

Sent: Monday, June 12, 2000 5:43 PM

Subject: [asp_databases] Using Access with ASP





> I am using an Access database which consists of only 2 columns.

> I have written some sql which accesses the database and checks to see if

> the code that was submitted on the asp page is in the database and also

> checks to see if the second column (Company Name)Value is 'NoName'.

>

> If the code is in the database and the other column contains the value

> 'NoName' then the column containing the value 'NoName' should be updated

to

> whatever the value for Company Name on the asp page was given as.

>

> This worked fine on my development machine.  However when I uploaded it to

> the server it dosen't.

>

> If I enter an invalid code it does what it is supposed to do and returns a

> message saying 'Invalid Code'.  However when I enter a valid code it gives

> me the following error 'Access Error: must be an updateable query'

>

> I have checked MSDN and found various things like make sure the DB file is

> writeable etc. but to no avail.

>

> I know the paths i am using to the database are correct because I've used

> Server.Mappath.

>

> Any ideas?  Would be greatly appreciated!

>

> Thank

>

> Alan

>