To demonstrate a small real life ADO application, we have put together a few ADO demos.

Read this First

If you try to update the database, you will get the error message: "You do not have permission to update this database". You get this error because you don't have write access to our server.

BUT, if you copy the code and run it on your own system, you might get the same error. That is because the system might see you as an anonymous internet user when you access the file via your browser. In that case, you have to change the access-rights to get access to the file.

How to change the access-rights of your Access database?

Open Windows Explorer, find the .mdb file. Right-click on the .mdb file and select Properties. Go to the Security tab and set the access-rights here.

List, Edit, Update, and Delete Database Records

List, edit, update, and delete database records

Add a New Record to a Database

Add a new record