472,993 Members | 2,122 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,993 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 2862
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: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

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.