473,387 Members | 1,463 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,387 software developers and data experts.

file attachment in vb 6 and access 2000

Hi

This is my second try... any takers?

I have an application that is up and running. Everything is working
perfectly. The application is written in VB 6 SP5 using Access 2000 to
store the data.

The users would now like to attach files (Word, Excel, etc) to the
records. I have no idea how to go about this :o( I am a Lotus Notes
programmer and in Notes I would have created a RichText field and they
could load and edit their attachment in it. How do I do this in VB?

I have tried to add a RichTextBox. When I drag and drop documents into
the RTB all that happens is I get a link to the origional document.
What I want is for the file to get copied into the RichTextBox. When
the user drags it out it gets deleted. When they double-click it gets
edited. Surely there is a control that has these basic functions?

Any help would be appreciated - just a pointer in the right direction
would be great ;o)

Thanx in advance
Ursus
Jul 17 '05 #1
7 5625
[posted and mailed]

ur*************@hotmail.com (ursus) wrote in
news:5b**************************@posting.google.c om:
Hi

This is my second try... any takers?

I have an application that is up and running. Everything is
working perfectly. The application is written in VB 6 SP5
using Access 2000 to store the data.

The users would now like to attach files (Word, Excel, etc)
to the records. I have no idea how to go about this :o( I
am a Lotus Notes programmer and in Notes I would have
created a RichText field and they could load and edit their
attachment in it. How do I do this in VB?

I have tried to add a RichTextBox. When I drag and drop
documents into the RTB all that happens is I get a link to
the origional document. What I want is for the file to get
copied into the RichTextBox. When the user drags it out it
gets deleted. When they double-click it gets edited. Surely
there is a control that has these basic functions?

Any help would be appreciated - just a pointer in the right
direction would be great ;o)

Thanx in advance
Ursus

Why not simply carry the files' path as a string variable on
your Access DB. That way, when you double click the path name
you can read your file into the RTB.
--
Robert L. Berman
Database consultant
Vulcan Software Services

Jul 17 '05 #2
Hi Robert,

thank you for your answer but we want to keep the file in the database
and not in the file system.

Basically what we want is a file repository! The documents are created
externally and the just stored in the Access DB.

Any other ideas?

Ursus


Robert Berman <No***********@earthlink.net> wrote in message news:<EP*******************@newsread2.news.atl.ear thlink.net>...
[posted and mailed]

ur*************@hotmail.com (ursus) wrote in
news:5b**************************@posting.google.c om:
Hi

This is my second try... any takers?

I have an application that is up and running. Everything is
working perfectly. The application is written in VB 6 SP5
using Access 2000 to store the data.

The users would now like to attach files (Word, Excel, etc)
to the records. I have no idea how to go about this :o( I
am a Lotus Notes programmer and in Notes I would have
created a RichText field and they could load and edit their
attachment in it. How do I do this in VB?

I have tried to add a RichTextBox. When I drag and drop
documents into the RTB all that happens is I get a link to
the origional document. What I want is for the file to get
copied into the RichTextBox. When the user drags it out it
gets deleted. When they double-click it gets edited. Surely
there is a control that has these basic functions?

Any help would be appreciated - just a pointer in the right
direction would be great ;o)

Thanx in advance
Ursus

Why not simply carry the files' path as a string variable on
your Access DB. That way, when you double click the path name
you can read your file into the RTB.

Jul 17 '05 #3
ur*************@hotmail.com (ursus) wrote in
news:5b**************************@posting.google.c om:
Hi Robert,

thank you for your answer but we want to keep the file in
the database and not in the file system.

Basically what we want is a file repository! The documents
are created externally and the just stored in the Access
DB.

Any other ideas?

Ursus


Robert Berman <No***********@earthlink.net> wrote in
message
news:<EP*******************@newsread2.news.atl.ear thlink.net
...
[posted and mailed]

ur*************@hotmail.com (ursus) wrote in
news:5b**************************@posting.google.c om:
> Hi
>
> This is my second try... any takers?
>
> I have an application that is up and running. Everything
> is working perfectly. The application is written in VB 6
> SP5 using Access 2000 to store the data.
>
> The users would now like to attach files (Word, Excel,
> etc) to the records. I have no idea how to go about this
> :o( I am a Lotus Notes programmer and in Notes I would
> have created a RichText field and they could load and
> edit their attachment in it. How do I do this in VB?
>
> I have tried to add a RichTextBox. When I drag and drop
> documents into the RTB all that happens is I get a link
> to the origional document. What I want is for the file
> to get copied into the RichTextBox. When the user drags
> it out it gets deleted. When they double-click it gets
> edited. Surely there is a control that has these basic
> functions?
>
> Any help would be appreciated - just a pointer in the
> right direction would be great ;o)
>
> Thanx in advance
> Ursus
>

Why not simply carry the files' path as a string variable
on your Access DB. That way, when you double click the
path name you can read your file into the RTB.


Ursus,

Check out APPENDCHUNK and GETCHUNK. I would think 1.2GB would
be sufficient to hold what you need. Look in VB HELP rather
than the ACCESS help file.

--
Robert L. Berman
Database consultant
Vulcan Software Services

Jul 17 '05 #4
ur*************@hotmail.com (ursus) wrote in message news:<5b**************************@posting.google. com>...
Hi Robert,

thank you for your answer but we want to keep the file in the database
and not in the file system.

Basically what we want is a file repository! The documents are created
externally and the just stored in the Access DB.

Any other ideas?

Ursus

The problem with storing the files inside the DB is that your DB is
going to get very big pretty fast. When it goes bang, you risk losing
all your files. You might want to read Larry Linson's FAQ on storing
image files, as this is similar in a some ways:
1. you want to be able to manipulate the files/search for them
2. you want to view them from your DB.
Jul 17 '05 #5
ur*************@hotmail.com (ursus) wrote in message news:<5b**************************@posting.google. com>...
Hi Robert,

thank you for your answer but we want to keep the file in the database
and not in the file system.

Basically what we want is a file repository! The documents are created
externally and the just stored in the Access DB.

Any other ideas?

Ursus

The problem with storing the files inside the DB is that your DB is
going to get very big pretty fast. When it goes bang, you risk losing
all your files. You might want to read Larry Linson's FAQ on storing
image files, as this is similar in a some ways:
1. you want to be able to manipulate the files/search for them
2. you want to view them from your DB.
Jul 17 '05 #6
The sample databases illustrating three approaches for handling images in
Access are at http://accdevel.tripod.com. Similar approaches might be used
to handle other types of file, except that a Bound OLE frame is likely to be
required for some types of document. You can't, of course, display just any
document in an Image control -- but the _storage_ techniques apply.

Larry Linson
Microsoft Access MVP

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
ur*************@hotmail.com (ursus) wrote in message

news:<5b**************************@posting.google. com>...
Hi Robert,

thank you for your answer but we want to keep the file in the database
and not in the file system.

Basically what we want is a file repository! The documents are created
externally and the just stored in the Access DB.

Any other ideas?

Ursus

The problem with storing the files inside the DB is that your DB is
going to get very big pretty fast. When it goes bang, you risk losing
all your files. You might want to read Larry Linson's FAQ on storing
image files, as this is similar in a some ways:
1. you want to be able to manipulate the files/search for them
2. you want to view them from your DB.

Jul 17 '05 #7
ur*************@hotmail.com (ursus) wrote in message news:<5b**************************@posting.google. com>...
Hi Robert,

thank you for your answer but we want to keep the file in the database
and not in the file system.

Basically what we want is a file repository! The documents are created
externally and the just stored in the Access DB.

Any other ideas?

Ursus


Ursus,
I agree with Robert. You could do what you're proposing, I guess, if
you use SQL Server. I don't think Access would be terribly stable for
that. Once it gets big, performance would probably not be very
pretty... What happens if you database crashes?
Jul 17 '05 #8

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

Similar topics

7
by: ursus | last post by:
Hi This is my second try... any takers? I have an application that is up and running. Everything is working perfectly. The application is written in VB 6 SP5 using Access 2000 to store the...
3
by: bill mahoney | last post by:
Hello, I am using access 2000 and I am trying to email a csv file. I have only used the docmd.sendobject command but you can only email objects that are within the access database ( as far as I...
4
by: John Baker | last post by:
Hi: Can someone point me in the right direction please? I need to use Access to e mail a variable report (in Word) to a number of individuals. Their names are in a table called Associates, and...
5
by: gteets99 | last post by:
I am trying to receive an Access database file that is attached to an emai. I am using Microsoft Outlook 2000. The email has a message at the top that the database file was blocked because it...
2
by: Ryan Taylor | last post by:
Hello. I am trying to upload a file and save it in a Sql Server 2000 database. This seems to be working fine. However, when I download the file from SQL Server, it appears that the page that is...
5
by: Daniel Corbett | last post by:
I am trying to save a file dynamically created in a webpage. I get the following headers, but cannot figure out how to save the attachment. I am basically trying to replicate what internet...
5
by: Sean | last post by:
Hi... I want to use the macro/sendobject (or any other procedure) to send the contents of a table (very small, ~5 rows/columns) as an Outlook message body, not as an attachment. Access 2000 will...
7
by: =?Utf-8?B?QU9UWCBTYW4gQW50b25pbw==?= | last post by:
Hi, I have been using the code (some of it has been removed for simplicity) below to allow authenticated (using ASP.NET membership database) users to get a file from their archive area. It...
1
KevinADC
by: KevinADC | last post by:
Note: You may skip to the end of the article if all you want is the perl code. Introduction Many websites have a form or a link you can use to download a file. You click a form button or click...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.