Error when trying to update Access database with ASP.NET on remote host server.

I set up a simple web application a few weeks ago and needed to make some changes.  I made the changes on my laptop in Visual Studio and it works fine on my laptop.  So I uploaded the entire project to the host server and now when I try to update or insert into my database I get this error:

Message: Operation must use an updateable query.
Native Error: -198839259
Source: Microsoft JET Database Engine
SQL State: 3073

I've seen this error before when I didn't give the aspnet account write access to the database.  I did have this working fine on the host server before and can't think of what is causing this error.  Anyone ever seen it before?  Thanks.
LVL 4
Ike23Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ike23Author Commented:
The first one says that it is because I am doing some sort of aggregate function in my query which I am not doing.  The second link is broken.
0
Ike23Author Commented:
I can get it to work fine on my laptop but when I upload it to the server I get an the error.  I have successfully uploaded the app and got it to work but now it won't.  Very frustrating since I am used to being able to simply copy a file or database and have the results show up without having to compile or whatever Visual Studio does...  Thanks for any help!
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

aprestoCommented:
the second link works ok for me but now you say asp.NET i dont think its much help
0
aprestoCommented:
im not sure its normally with permissions on the database.  SOrry i've looked around the net and EE but they all say the same thing.  Good luck and sorry for not being a of great help
0
aprestoCommented:
If worst comes to worth, sorry i just thought of this, Copy all of the tables from the database into another database, then name it the same and delete the old one, this may solve it

Hope it helps, sorry for the delay :o)
0
Ike23Author Commented:
Turns out that the host company had to set up the folder with permission to write to the database.  Weird because its the same folder as before and it worked fine without me doing anything.  The pains of learning a new language I guess....
0
aprestoCommented:
Ah right, well atleast you got it sorted, its a pain in the ass when things like that happen, sorry i couldnt help you much on this occasion.  Take it easy

Apresto
0
moduloCommented:
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.