How do I fix a database that will not close even though record sets and connections are closed?

Question

Created an Intranet, web application using Classic ASP that's currently connected to an Access database. Mysteriously, when some User's accessed the application and tried adding, deleting, or updating data, they would receive: "Arguments are of the wrong type...800A0BB9...etc..." The error would always occur on the line where the recordset is open.

I then reviewed and updated the code to ensure that all record sets and database connections are closed upon use; cursor types were appropriate for the SQL action: i.e. add, update, delete; resolved any syntax issues; matched data types. The database is on a Windows 2003 Server.

Even after these changes and sucess on my local and test windows' server, when data is added, updated, or deleted and I've closed the browser, the database remains open for hours; displaying a lock file. I don't get the "Arguments error" but because it randomly occurred, it may still for someone else.

This database currently uses a .mdw file for security and was once a standalone application that used Access Forms to process the data that the web application is supposed to do now. There were many settings and querys used to manage data.

What do I need to check in the code and/or database in order to resolve this error?

Answer 1

The internet is a disconnected model - the browser connects to the server, asks for a page and gets it. Period. Whether you sit and stare at it for hours or immediately close the browser (or navigate to a different site), the site has no way of knowing whether you're still there. The database, if you leave the connection open, will continue to be locked for the default timeout period of the site, which could very well be hours. You can set a timer (reset it with every hit from that session) or just make sure that you close the connection every time it's opened (that reduces efficiency a tiny bit, but makes it a lot easier to keep the site running). Open the connection, run the query, close the connection. At that point, the database is no longer locked. (If it is, you have a problem that has nothing to do with the web page locking the database.)

Answer 2

The first issue is that access was never designed to be multi-user. In some cases, you can maintain around five users successfully, but on the web side, that is a completely different story. The random locking is normal.



To resolve this, you must stop using access and switch over to Microsoft SQL Server 2005 Express Edition.



You can download it for free at the following address:



http://www.microsoft.com/DownLoads/details.aspx?familyid=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en



You can download a program to convert and access file to SQL file using the following address:



http://support.microsoft.com/default.aspx/kb/237980





The only thing you need to be careful of is that the wildcard character changed from * to %

Answer 3

i'm the youngest of four babies. I, Kristina, only grew to become 20, my sister, Angela, is nearing 22, my oldest sister Jessica is 26, and the only boy, Tony, is 28. My brother and that i used to be somewhat close, yet we've been 8 a million/2 years aside so even nonetheless he spoiled me he grew to become into especially lots in extreme college then out of the homestead earlier i grew to become into sufficiently previous to remember the techniques we created. Now nonetheless he's largely a grumpy previous guy. no longer as social as he was and as I entered my teen years, we stopped being as close. he's married now with 2 young ones. i admire my nieces and nephews nonetheless. My sister Jessica used to babysit me lots turning out to be up. She grew to become into somewhat mean or perhaps nonetheless i had important spunk as a baby and did and suggested issues that made me geet beat up by ability of her, she scared me to loss of life lol. I kinda understand why she grew to become into so mean now that i'm older. right here she grew to become into interior the best of her babies getting caught watching me and my sister continuously. in all likelihood with little to no pay. Now she's married with a baby. we are especially distant nonetheless. never somewhat been close. My sister angela and that i needless to say grew up together, being basically a million year and 9 months aside. Her and that i are especially close and that i call her now and lower back to chat. Our personalities conflict nonetheless as we are no longer something alike. i'm very self sufficient and she or he's particularly based on anybody. for the time of our lives we've been especially close. Had our sibling rivalries yet we controlled.