webservice + MS Access lock

[bioS]

Hello,

I'm writing an application which will have a part on the web (ASP.Net) and another will use a webservice from a client application. Some of its methods use another class which is used to connect to an Access database.

When I use this second class from my ASP.Net pages, everything works fine.
But when I use it from the webservice, a lock (.ldb) stay on the server, even if I close the Connection and the DataAdapters.

Do you know if there is anything special to do when using a webservice ? (it is the first time I build one...)

Thanks for your ideas.

[PeOfEo]

I would use an xml data base. Access is alright for small things but it has its share of problems, for example only 10 people can be logged into it at one time or it will lock up. You are probably using a lot of xml already right so whats a little more for a data base? It just seems like the more logical choice, unless of cource you have access to mssql or msde.
BTW: Webservices are amazing I am learning about them too, I am pallning on working on a bot for battle net which uses an os similar to irc. Once I get better with java and actualy start I am thinking of using an xml webservice to update my mssql data base and then have that data base go through an output onto the site. It just seems like the easiest way to host a live chat through my site when going through irc or something. Check out my live feed that I have now, http://www.clanknights.vze.com I am using someone elses bot and stuff its called webbot. I am puzzled about how they did it because it uses no data base, What I heard is they have a central server hosting the data bases which are very small and numerout and those are constantly update by the bot and that genorates the channel list. The text on the other hand does not go through the server, the text in the room and the chat text goes through a port on my comp to the bot so I am running that as a server basically. Its pretty neat.