Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

Operation must use an updateable query

Problem: If you have .MDB file as your data store for your ASP.NET (assuming hosted under IIS). It will work in your local machine (all CRUD operations) but when you try to access your site from external system which performs update/insert operation, it will throw exception.

Reason : ASP.NET account requires security permission to do CRUD operation on MDB files.

Solution : Add ASP.NET account as a part of Admin user / equivalent to admin user, then assign ASP.NET account to the required site.

  1
Advertisements

September 1, 2009 - Posted by | Uncategorized

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: