Storing Attachments in Access DB

[Guest]

--
Hansford D. Cornett

 

[RobFMS]

I recommend storing the links (location where attachment) only. It will not
bloat the system.

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Scott]

Rob,

Is there any example how to submit the attachment and link in the Access by
normal user?

Thanks,

Scott

 

[RobFMS]

In the field, just store the full path and filename.

Example:

Field: SampleDocuments
FieldValue: C:\WordDoc\Samples\AprilPressRelease.doc

HTH

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Scott]

Rob,

We would like the user to submit the attachment to the server, not linked to
the folder on their computer. It is something like the attachment submitted
to web mail.

Scott

In the field, just store the full path and filename.

Example:

Field: SampleDocuments
FieldValue: C:\WordDoc\Samples\AprilPressRelease.doc

HTH

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[RobFMS]

The example given, was just that ... an example.

Use can use a UNC path (i.e. \\<ServerName>\<Directory>\....



--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com