how to uploade a attachement to database

[Guest]

hi,
can any body tell me how to upload a file e.g. message format or word file
to the database
thx.

 

[John W. Vinson]

hi,
can any body tell me how to upload a file e.g. message format or word file
to the database
thx.

It might help if you could describe what you mean by "the database".

Do you want to put a Word document INTO an Access database? That's
possible, but probably a bad idea: it will bloat your database very
rapidly.

And I have NO idea what you mean by a "message format".

John W. Vinson [MVP]

 

[Guest]

hi John,
the database is MS database for employess
message format is outlook message format
could you please tell me how

 

[John W. Vinson]

hi John,
the database is MS database for employess
message format is outlook message format
could you please tell me how

You'll have to explain more clearly.

Microsoft sells four different database formats (or more, just four
off the top of my head): SQL/Server; Visual FoxPro; Microsoft Access;
and (marginally a database) Works. These are all "MS databases".

You say "for employees". I have NO idea what that means, what
information you want to store, who will be using it, how they will be
using it...

Please clear your mind of your business, and read your posts with the
attitude that you've never heard of this person before and have no
idea what they're doing or how their business is run. Is there enough
information in your questions to figure out what you want?

John W. Vinson [MVP]

 

[Guest]

hi,
i just need to know how to attach an attchment to the database please

 

[Gina Whipp]

Pardon the intrusion...

If you are trying to attach your database to an Outlook eMail and you are
asking for instruction, I would suggest you ask in the Outlook newsgroup.

If you are trying to attach something to a Microsoft Access database and
then send via Outlook, the simple answer is no you can't. You will have to
zip all the files you want to send and then send via Outlook.

If niether of the above applies, you will have to answer John's question(s)
in order for anyone to help or at the very least point you in the right
direction.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Ron2006]

For Microsoft Access you do NOT attach a document to a/the database
like you attach something to email.

You can save the file name and directory in a txt field and therefore
use a followhyperlink with that data to open the file, but it is not
attached.

Ron

 

[John W. Vinson]

hi,
i just need to know how to attach an attchment to the database please

A database is not a message. You cannot "attach" anything to it.

You can store data - or objects - IN a database table, but it is not
clear what you want to store or what you want to do with it.

John W. Vinson [MVP]

 

[Guest]

Hi,
Thank you all for your time and usual cooperation
But I have something for you, have you seen the template which is called
"customer service". It has filed called attachments. Unfortunately, I could
not download it. There is a problem with it. If you need to see it! Please go
to Microsoft Office Online and type "customer service.
I am waiting your reply.
Thx

 

[Guest]

By the way, the attachments that I want to store them at the database are all
extension e.g. doc. Html…….

 

[John W. Vinson]

But I have something for you, have you seen the template which is called
"customer service".

No, I have not; and you have not mentioned it anywhere previously in
this thread, so I did not know that you were using it.

Again: *We cannot read your mind*. *We cannot see your screen*. *We do
not know what you are asking unless you ask it in a way that can be
understood*.

I took a look at the Office website and found an Access2007 template
for Customer Service. However, I have not installed Access2007 and do
not plan to do so right away (until I get my second computer set up),
so I'm afraid I cannot help in that way... but I'll do my best.

An Access table Field has a datatype - it might be Text, or Memo, or
Hyperlink, or OLE Object. If you open the table in design view, what
is the datatype of the field named "Attachments"?

John W. Vinson [MVP]