How to send a database that is being used by another process to email c#

Question

In my program I am sending a database in the form_closed event to my email , in in form_loadevent I want to get the database from my email and to use it . I'm doing this to get the database from another computers in my project.

but the problem is in this line :

Attachment database = new Attachment("DataBase\\USBrowser.accdb");

I get an exception that the database is being used by another process , how to deal with this problem ? can I stop the database of being used by another process? ,, any other suggestions are welcomed .

thanx in advance

Are you by any chance reading the file at form_load and not disposing of the object? — Rodrigo Silva, Feb 28 '14 at 15:05
After the project is closed and disposed, when I enter it again I want to get the database — Karam Najjar, Feb 28 '14 at 15:07

score 1 · Answer 1 · answered Feb 28 '14 at 15:06

1

If your program is using the database then you will need to stop the database before using it.

You might also be able to make a copy of the database before attempting to add it as an attachment and then add the copy.

answered Feb 28 '14 at 15:06

CathalMF

9,705
6
70
106

can I make a copy of a file that is used by another process ? – Karam Najjar Feb 28 '14 at 15:08
It depends on how the "other" process is reading it. Ill update my answer to include some code in a minute. – CathalMF Feb 28 '14 at 15:11

score 0 · Accepted Answer · edited May 23 '17 at 10:30

0

If the issue is:

How to read a file being used by another process?

Then you can access it in "read mode":

Stream stream = File.Open("DataBase\\USBrowser.accdb", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
            StreamReader streamReader = new StreamReader(stream);

Original answer

edited May 23 '17 at 10:30

Community

1
1

answered Feb 28 '14 at 15:12

Rodrigo Silva

432
1
6
18

score 0 · Answer 3 · answered Feb 28 '14 at 15:18

0

Also, you might want to find out if another program has it open (Excel or something)

Process Explorer can help with this:

http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

answered Feb 28 '14 at 15:18

Thomas Taylor

555
4
12

How to send a database that is being used by another process to email c#

3 Answers3