Rookie having problems with getting read-only .mdb to allow writing 1

[dwfresh]

Hi,
I am trying to make modifications to a database that is read-only and have followed all the steps to making this Acces DB a writeable database.
I have gone to my particular directory where the .mdb is, (right click) Properties>Security Tab, and have made sure
that the 'Write' box is clicked on.
Basically, Ive done exactly what most people tell me to do in order to get the correct security settings.
But when I run my .aspx page, I get the error:

"System.Data.OleDb.OleDbException: Operation must use an updateable query."

Can anyone help me out here!!
Is there something else that I may be missing. I've spent hours trying to fix this!!!

thanks so much!

 

[LittleSmudge]

In Windows Explorer - Right Click on the xxx.mdb file and in the GENERAL tab - make sure that the Read Only attribute is clear.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[KenReay]

HI

You do understand that some Queries are simply NOT updateable don't you?

For example agregate queries are not updateable becuase any result column is the sum of many individual columns, and an thus there is no single point to which to apply the update.

There are various other circumstances under which a query may be none updateable.

If you did understand this, then sorry for wasting your time.

Hope this helps. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[dwfresh]

It worked, thanks Little Smudge!!
one of those t hings you overlook and you can't believe you didn't think of yourself.
thanks a ton.
Thanks to Ken too, that is helpfull info in the future!