Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

.ADP ACCESS PROJECT - Is it possible to create a form with an attachment button?

Posted on 2013-11-16
6
Medium Priority
?
511 Views
Last Modified: 2014-01-22
I would like on my form to have an attachment button that can store .tif / .pdf / .jpg / .gif  in the SQL DB

Is this possible in an access database connected to SQL SERVER 2008 running as .ADP access project?
0
Comment
Question by:Dale Massicotte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 39654286
Hi,

you cannot use the native attachment functions of Access as this is a ACE-only feature. But you can of course use the varbinary(MAX) datatype of SQL Server to store any kind of binary file into a column of a table in SQL Server.
I recommend to use an own table which holds such attachments and not add a varbinary(MAX) column to your normal tables because that will slow down the performance a lot. Using an own table has the advantage that you need the attachments only when the user wants to download one.
If possible you should consider to better use a separated fileserver to store the files and to present a link to the file in the database, otherwise your database size will grow very fast.

Cheers,

Christian
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39654470
I agree with Christian; you do NOT want to store binary objects inside a DB. Store pointers to them on disk.

Additionally the ADP support effectively ended with Access 2003, even though they will still work with newer versions of Access.
0
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 39654504
Hi jimpmen,

to be exact: In A2013 ADPs were removed from Access. But it is still possible to work with ADPs normally up to A2010 with SQL Server up to 2008. I personally also prefer to use ADPs instead of ACCDBs because of the JET/ACE in between which makes it really harder to work with SQL Server.
To avoid problems with updating frontends I use a terminal server which holds the A2010 runtime frontends so the user can install on his machine whatever he likes and the database frontend will never have a problem unless the database server will not be upgraded to a newer version.

Cheers,

Christian
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 800 total points
ID: 39654544
Christian,

I meant that support went away in the sense MS never created an AccDP standard that is like the mdb to AccDB change.

I always shied away from ADPs because of all the networking issues. The companies I have worked for have always had segmented networks that made it harder to get good connectivity from workstations to the SQL Server(s).

Another difference is that most of my stuff is ETL tasks, not OLTP.

So if the database is designed correctly it is easy to put data into a DB with DAO or ADO or extract to an import standard and then get it imported into another DB.

Regardless, to the asker's question. The storage of a binary data in the DB is never suggested. The only way I would support it is something like the logo.jpg for a report or a single form.pdf to be sent with an e-mail. Beyond that it should never really be contemplated.
0
 

Author Comment

by:Dale Massicotte
ID: 39687264
jimpen & Bitsqueezer

do you have any code samples of how I might be able to use a pointer (saving to a specific network share folder) via CMD BUTTON.

For example if there  is no file stored the CMD button would prompt user to save file and would actually save the pointer.

If the pointer was stored then the CMD button would retrieve the image file via the pointer that was stored.

Our customers on-line would then be able to retrieve the document via .aspx page
0
 
LVL 24

Accepted Solution

by:
Bitsqueezer earned 1200 total points
ID: 39687395
Hi,

Access can store and present a URL as hyperlink in a normal text field. That's all you need to do and then present this URL to the online users, if they click it it will download the file from this URL (the user must of course have access to it).

No code needed for this functionality.

Cheers,

Christian
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

670 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