weird app runs fine on win 2000 but not on 98

[hemenkap]

hi,

i have created an application in VB.NET using Access XP as the backend ( actually i use it with SQLserver also ) all i do is change the connection string of the oledbconnection.

now i have teste my application on XP as well as Windows 2000
but when i try to use it on 98 it works fine by retriving the data.
when i try to insert a record it inserts it also. however when i try to update a record it gives me a concurrency error even when i am the only person using the application and even when access database is closed.

help please.

 

[Robby]

Is it possible you left a connection open from another part of the project?

 

[hemenkap]

hi robby,

no i hacve taken care of this too. i have made sure that whenever i open a connection i do close it.
my problem is that it inserts rows fine but when you update an existing row it gives error. i will try to create a sample project and paste the code in the meantime if you have any ideas as to wh this is happenning do reply.

Hemen Kapadia

 

[APaule]

Hi Hemen,
how do you manage the updating?
Do you use a DataAdapter Update method, or a single Command Object?
Try if there is a difference or if both methods produce that concurrency.

 

[hemenkap]

hi,
i am using the dataadapters update method to update the data written in the tables stored in the dataset. also i am using transactions to do so.

one important thing is that the code works fine in Windows XP
and Windows server 2000 with both access and MS sql server 2000

however when i tried it in win 98 using MSDE it works fine but the same code gives this concurrency erro with access in 98.

god knows why?
i tried to figure it out but in wain.please help....

 

[jfackler]

Can you post the error message?
XP and NT utilize different security than 98. Is it a sharing violation?