Solved

Change default image size for attachments Access 2013 web app?

Posted on 2013-01-10
6
999 Views
Last Modified: 2013-01-10
Hello. I am playing with the Image DataType in Access 2013, when creating an app for use in SharePoint 2013. It works fine, however I cannot see where (if possible) to change the default web image size after upload is complete via the form entry. All attachments end up on the server with a default of 384x500 px. Can anyone help me make that larger?
0
Comment
Question by:J-Rodder
  • 3
  • 2
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38763942
Note that Office 2013 is brand new.

So let's see if an Expert here has some insight...
0
 

Author Comment

by:J-Rodder
ID: 38763956
I am having trouble even finding the detailed documentation I would need to solve it myself.
Right now I am thinking it would be set somewhere in Access, but just not seeing it. That means it could be somewhere in the SharePoint settings, or even something that needs to change in the SQL database itself. *shrug*
0
 
LVL 57
ID: 38764010
I don't know for sure, but I believe it's not changeable.  A web database's interface is "as is" and you can't modify it.

A2013 Web databases are like Access version 1.0; it worked, but there wasn't much you could modify or change.

Jim.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:J-Rodder
ID: 38764023
I surely hope not. To hardcode something like setting image dimensions would be a strange design plan. Admittedly though, I am largely ignorant of all the dependencies, so it might be easier said than done. Sure I could do it via linking urls from documents elsewhere in sharepoint, but that's too intensive for me to expect the data entry people to actually do. Browsing to a file from the network share while in a form is much more realistic. Maybe I need to try scanning the document at that resolution and see if its at least legible.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38764189
<<I surely hope not. >>

 When you publish a web databsae to sharepoint, all the presentation stuff is hardcoded and there's no way to change it that I'm aware of.

 What you see in the web database form is what your stuck with.

 Yes does seem odd, but this is really a first effort on Microsoft's part.  2013 is totally different in terms of what it offers for the web vs 2007/2010.

 Frankly, with the restrictions it currently has, there are few that are using Access Web databases that I'm aware of.

  2013 is brand new and is not really out there yet, but I don't believe what's in 2013 is going to change that all that much.  It's still too restrictive.

Jim.
0
 

Author Comment

by:J-Rodder
ID: 38764209
*edit*

I am using it because that's what my boss has tasked me with, he insists on a web accessible database, and I don't know any other way to go about it. It should be functional enough for now I suppose.

Maybe I can hope for future versions that allow more flexibility in document attachments. Something like an automated process for uploading the full document as a file into sharepoint, and creating a URL/thumbnail for display in the form. For now I'll just cross it off as an option I guess.

Essentially I have the invoice table with some data, and wanted to link to the actual image of the invoice sheet as well, after it was scanned by the employee to a network share.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dsum Function for List Box Data 7 48
hit enter key to run macro 13 24
IIF help, YN field 7 22
MS Access from Delphi 31 33
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question