Connection to Access Database

That's what to me when I changed to Discountasp. For whatever reason when you ftp to discountasp the Access database is a read only database so I change from read only and now it works find.

 

When I moved servers from another provider to DiscountASP, I lost the ability to update my database from my website. I can still read information out of the database, but am unable to insert anything into it. I get an error that says operation must use an updateable query. I don't know how to set the privileges on the file to be executable, or if that's not the problem, I don't know how to make the correct connection in the ASP code to be able to insert information. Please help!

Kevin Carden
churchattuscaloosa.com

 

The best way for you to fix that problem depends on if you have a fpdb folder on your site.

If you do delete it.

If you don't then here's what you do.

First make sure your local copy of your access database is not readonly.

Open a new page from the templates and choose feedback form.
Goto the form properties and select send to database. In the options select let front page create a new database for you.

It will automaticall create a new fpdb folder and give the files in it Write access but disallow /fpdb/your.mdb access via the web.

Then copy and paste your local db in the fpdb folder through front page.

Delete the generic database and the generic page.

This will allow write access.

Another way is to get the sysadmin to browse to the file locally and remove the readonly check.

Hope this helps.


gninthgiLevitaerC