Hi Josh,
It can but warning your database will bloat (i.e., get too big for Access
to handle) resulting in constant corruption. Recommendation is to store
the paths of the Documents in your database an read the paths from the
database in your Web application.
Note: Access file maximum file size is 2 gigs minus the System tables
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
--------------------
| Content-Class: urn:content-classes:message
| From: "Josh" <
[email protected]>
| Sender: "Josh" <
[email protected]>
| Subject: Storing documents in Access
| Date: Wed, 18 Feb 2004 10:40:41 -0800
| Lines: 9
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcP2TrWa9FXyPrk6SISoz+5Fvg7liw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.setupconfig:29115
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| Is it possible to store entire documents, such as a
| resume created in Word, in Access? I am trying to add a
| feature to our corporate intranet that will allow
| employees to browse resumes and writing samples by
| position applied for and want to avoid having to strip
| out resume data and manually input it into our Access
| DB. Instead, I'd like to simply have our Web App Server
| query Access and pull up the ENTIRE document. Can this
| be done? How?
|
