Adding a record in Access 2000 via ASP 1

[Dijital]

I have a simple ASP page for entering requisition information into an Access 2000 Database. I have never used permissions in Access before, so I'm kind of in the dark. Right now, when I try to add a record, I get permission denied. I can post the code if needs be. any help would be great.

-Jim Connors

 

[krisbrixon]

You need to make sure the web server has rights to directory of the database.

You need to make sure IIS is set to allow the use of ASP and writing.

After that here are some beginner asp/database pages:

http://www.asp101.com/samples/db_add.asp

http://www.devguru.com/features/tutorials/ADOandASP/adoTutorial.html

http://www.kamath.com/tutorials/tut001_access.asp

http://www.aspalliance.com/glenncook/searchcode.asp

I hope this helps

Kris
- To err is human, but to really foul things up requires a computer.

 

[Jonid]

check if the file is open in design mode by access or any other application which uses the database exclusively.
.

 

[asmith555]

Ensure you IUSER or whatever the internet guest account is has write permissions to the directory and database.