Hi,
I have another in the same chapter and here is the problem

Server Error in '/BegASPNET' Application.
--------------------------------------------------------------------------------

Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

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

Source Error:


Line 89: ' ================================================== ===============
Line 90: ' update the data store
Line 91: objAdapter.Update(objDataSet, "Employees")
Line 92:
Line 93:


Source File: D:\BegASPNET\Ch13\synchronize.aspx Line: 91

Stack Trace:


[OleDbException (0x80004005): Operation must use an updateable query.]
   System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +1550
   System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +152
   ASP.synchronize_aspx.Page_Load(Object Sender, EventArgs E) in D:\BegASPNET\Ch13\synchronize.aspx:91
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +29
   System.Web.UI.Page.ProcessRequestMain() +724




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0

if u guys need code i will send it too

Thanks

Mahir Ali Ahmed

__________________
Mahir Ali Ahmed

Hi Mahir,

This is probably a security issue. Does the ASPNET account have sufficient permissions to write to the .MDB file and the folder that holds the database?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Careless by Urban Dance Squad (Track 9 from the album: Life 'n Perspectives of a Genuine Crossover) What's This?

Hi,
I don't know about that, in my pc in which i am using xp pro i have 3 accounts one is of my name administrator account one is sql account and on is aspnet account.
Can u please help me how to check it.
Thanks

Mahir Ali Ahmed

Hi Mahir,

Check out this article: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263
It deals with setting the permissions for the database and the folder where the database is placed. The first part does not apply to you (it's targeted at "classic" ASP), but be sure to check out the section "Changing the Security Settings", somewhere half way down the article.
In your situation, don't set the settings for the IUSR_Account, but for the ASPNET account instead.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The Sound Of Fear by Eels (Track 3 from the album: Daisies Of The Galaxy) What's This?

hi Imar,

I checked that site actually i dont have the security tab which is mentioned in the article, what should I do now.

Thanks

Mahir Ali Ahmed

Good point. I should add that to the article.....

By default, when you install XP Professional, an option called "Simple File Sharing" has been enabled to ease the process of sharing files between users.

To disable this feature, open a Windows Explorer and then choose Tools | Folder Options... On the View tab, scroll all the way down and deselect Use Simple File Sharing (Recommended).

Although "recommended" by Microsoft, disabling this feature will give you back your security tab and the ability to have fine-grained control over your security settings.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Tunic (Song for Karen) by Sonic Youth (Track 2 from the album: Goo) What's This?

Right. I just checked, and it *is* already in the article. The part I pointed you to says this right at the start:
And then it is followed by the explanation.....
Did you actually read it??? ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Tunic (Song for Karen) by Sonic Youth (Track 2 from the album: Goo) What's This?

HI,

Thanks for the Article yes it has what u mentioned above I read it carefully and now my worries are over.

Thanks

Mahir Ali Ahmed

Hello folks,
    I have the same problem under XP SP2. I just unchecked the "Simple File Sharing" option. Now, the "Sharing" tabs seems different but [believe it or not] I still can't see any security tab! Is this because of SP2? Or maybe because my HD is Fat32 instead of NTFS?


Need advice,
Justin

Hello,
    I finally found the answer. Two reasons for this:
        - The Database file was set to read-only (probably when I copied it)
        - A FAT32 partition doesn't have the "Security" tab.

Hope this could help someone having the same problem.
Regards,
"An happier Justin"