Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Document Mgmnt and SQL Server
Jennifer Neighbors 
     
2 years ago
One shouldn't use attachments in Access to store images or documents. I've written a database I like that manages documents by storing their locations. It can 'read' the document contents from documents in Word or PDF format and store the resulting text. I'm working on a new database with SQL Server as a back end. Does that change things at all? Would I do things differently to include document management in this new database? Does it create some new possibilities? I'm looking for general direction and suggestions from developers who are experienced with SQL Server.
Juan C Rivera  @Reply  
            
2 years ago
When setting up access to work off a server, it's important to ensure you have the necessary permissions to perform tasks like moving files and creating directories. This helps maintain organization and security across shared resources. If you're unsure about your permissions, it's always a good idea to check with your IT administrator or the server owner. They can assist in granting you the appropriate access levels so you can carry out your work efficiently and without any hitches. Friendly communication and cooperation in these matters ensure smooth collaboration and adherence to organizational guidelines, promoting a positive and productive working environment for everyone involved.
Adam Schwanz  @Reply  
           
2 years ago
There are some data types that could store documents on sql server like blob, but I've never used them. I've always used a seperate file server/web server to store images/attachments, you can get a "file location" on the web server and just use that as the file location, most of the rest of the stuff should be the same.
Jennifer Neighbors OP  @Reply  
     
2 years ago
Adam, I'm unsure what you mean by "file server" in this context. Can you expand on it a little? Would I ask WinHost.com to provide that? Also, how would the documents get to that location? I need a bit more explanation. Thanks!
Adam Schwanz  @Reply  
           
2 years ago
It's basically just a web server for your files. Same thing as a normal server in your LAN but cloud based. One example I've used is Amazon Web Services(AWS), I think Richard uses Wasabi. You just set your files on it and you should be able to get a link to reach your document. You should be able to use that link in place of a network location in your database.

As far as how the files get there, kind of depends what you use and what types of files your putting up. The most basic way would be with FTP.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/8/2026 9:53:01 AM. PLT: 0s