How to send .mdb file by mail through VB.NET

Question

0.00/5 (No votes)

See more:

HI I have made a software that has to mail the *.mdb File in my bin folder of the Application.When i attach a jpg file to this mail the Mail is sent successfully but when i attach an MDB file (Microsoft Access File) then i get an Exception "An invalid file attachment ...Niigata.mdb" where Niigata.mdb is my Access file that i want to mail.
Can anybody please help me with this problem.

What I have tried:

i am using this code for sending mail.

VB

mail.Attachments.Add(New Attachment("C:\Users\okookkoko\Desktop\xyz.mdb"))

not possible to send

VB

mail.Attachments.Add(New Attachment("C:\Users\okookkoko\Desktop\image.jpg"))

possible to send??

Posted 24-Mar-18 22:28pm

Member 13707533

Updated 24-Mar-18 23:30pm

OriginalGriff

v4

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-03-24T23:07:00

If the JPG file goes, and the MDB file doesn't there are a couple of possibilities:
1) The MDB file is in use and can;t be opened in order to copy it into the email. Check your code and see if you leave any Connection objects unclosed, and undisposed. If your app is "holding" the file, it won;t be openable by the email system.
2) The file is too big for your email system rules. Some systems will restrict the size of outgoing emails so you don't annoy the heck out of people with slow / expensive data connections. Check the file size, and look at your email system rules.

Maciej Los · Answer 2 · 2018-03-24T23:12:00

Solution 2

If you're talking about Outlook, check this: How to: Programmatically Attach Files to Outlook E-Mail Items[^]
As the documentation[^] states, Attachments.Add method gets 4 parameters:

VB.NET

expression . Add( Source , Type , Position , DisplayName )

Posted 24-Mar-18 23:12pm

Maciej Los

Patrice T · Answer 3 · 2018-03-24T23:32:00

Size of attachments is limited in mails, and that is your problem, it's your ISP.
Mostly 2 solutions:
- find a mailing tool that can slice your attachment in parts and make multiple mails according to the size limit.
- use some kind of 'DropBox' service to store your file on internet and send a link to your file.

How to send .mdb file by mail through VB.NET

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0