This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Storing attachments in Access? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Storing attachments in Access?" Watch "Storing attachments in Access?" New topic

Storing attachments in Access?

Theodore Casser
Ranch Hand

Joined: Mar 14, 2001
Posts: 1902

Before I start, yes, I realize Access is not an ideal database solution.
I've been asked by a coworker to write a JSP/Servlet front-end to an Access database in which we're storing our data on requested enhancements to an application, so the developers can access the list and update it from their desktops. The problem is a request to be able to attach up to two files to these requests.
Anyone have any ideas how I can 'convince' Access, by the JDBC-ODBC bridge, to store the files?
Thanks in advance.

Theodore Jonathan Casser
SCJP/SCSNI/SCBCD/SCWCD/SCDJWS/SCMAD/SCEA/MCTS/MCPD... and so many more letters than you can shake a stick at!
Theodore Casser
Ranch Hand

Joined: Mar 14, 2001
Posts: 1902

Let me refine this, since I seem to be attracting very little in the way of help.
I've figured out how to get JDBC to store the uploaded file... but not in a format I can use. (It's storing it as binary data, which is great, but I need to be able to retrieve the file in its original format for use.) Any thoughts on what I'm doing wrong?
jQuery in Action, 2nd edition
subject: Storing attachments in Access?
Similar Threads
BLOB & CLOB - SQL Server
HashMap - in-memory caching - multi-threaded environment ?
Saving doc and rtf files in Sql Server
Stand-alone Databases
how to insert a picture in database