Sleeping process

[rejome]

Hi guys,

Using CurrentDb.OpenRecordset with Access 2000 thru linked tables, I have sometimes an error when I try to edit some of my data: "Writing conflict. An other user is trying to edit your data, yakyakyak". As an admin, I see that in the same time that I use OpenRecordset, I create a process in our MSSQL, which is now sleeping. I suspect that it could be the source of the problem. What do you think about that? Any ideas for solving this?

 

[rejome]

Well, I'll auto-answer my own thread, cause I found the reason why. The problem comes from the fact that I had some BIT fields in MSSQL, converted in Yes/No in Access. The Yes/No field can takes NULL as a value but not the bit one. I just put 0 in MSSQL as the default value, relinked my table in Access and voilà!