473,394 Members | 1,944 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Error: The process cannot access the file ".mdb" because it is being used by another process.

Hi,
I use ADOX to create a Access database programmatically from my asp.net
application
and save ".mdb" file to a temp folder under my project foler on the web

server. After database is created successfuly, I saw two files ".mdb"
and ".ldb" in my temp folder. I have no problem to open the database
manually. But when I'm tring to use Response.WriteFile() to download
database file to end user's local machine, I kept getting the following

error message - "The process cannot access the file ".mdb" because it
is being used by another process."
Any help is highly appreciated.

thanks

Nov 19 '05 #1
2 2887
Well, If you see ldb file that means connection to DB is open.

Did you explicity closed the connection? Or that ADOX object.
Probably not

George.

"lucy" <yo****@profitecinc.com> wrote in message news:11**********************@z14g2000cwz.googlegr oups.com...
Hi,
I use ADOX to create a Access database programmatically from my asp.net
application
and save ".mdb" file to a temp folder under my project foler on the web

server. After database is created successfuly, I saw two files ".mdb"
and ".ldb" in my temp folder. I have no problem to open the database
manually. But when I'm tring to use Response.WriteFile() to download
database file to end user's local machine, I kept getting the following

error message - "The process cannot access the file ".mdb" because it
is being used by another process."
Any help is highly appreciated.

thanks

Nov 19 '05 #2
Thank you very much for your response. I use try...catch..finally in my
source code. And in finally block I set cat.ActiveConnection = Nothing

cat = Nothing
where cat is adox object.

What else am I missing?

thanks

Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Fie Fie Niles | last post by:
I have IIS installed on XP Professional workstation machine. I have an ASP page that open connection to an Access database, then when trying to update the database, it gave me the error "cannot...
3
by: Henrik | last post by:
How do you access another window? For example if u whant tpo write something in a textbox in an other opwn window?
2
by: Ingvar Nilsen | last post by:
What I want is to have an ASP.Net web application access another web page (not a web service), get the response content from this, do something with it and send it back to the client. Have...
2
by: Homer J. Simpson | last post by:
Hi there, Does anyone know a working tip to avoid an external js file being cached, whathever the client cache policy is ? Thanks in advance, J. Philippe
5
by: MLH | last post by:
What is the meaning of this error? Operation Must Use An Updateable Query ???
2
by: Susan Baker | last post by:
Hi, I am (trying) to compile some code I downloaded from the internet. The sources contain references to header files - using the form : #include <pathname/file> If I change the form to...
2
by: terry | last post by:
Hi, I am using a FrameSet with three frames. In server code (c# code behind) is it possible for a page to call a function in another page of the frameset? I suspect that it is not possible but...
1
by: crka.crka | last post by:
Does anyone know a way to prevent a file being deleted so the only way to delete is via unistallation? Help would be very much appreciated.
10
by: vunet.us | last post by:
What is the workaround of passign a parameter to any included asp file: <!-- #Include File="file.asp" --> This obviously does not work: <!-- #Include File="file.asp?id=123" --> Thank you
9
by: tshad | last post by:
I am trying to get access to a file that may still being written because the file is so large (7-10MB). I get an error: The process cannot access the file 'c:\TestDocs\XMLFiles\492172.XML'...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.