473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Batch Upload to Access DB via ASP

Hi,

I'm hoping that some of you will have experience with uploading images
via ASP to an Access db on a remote server. I've scoured the threads
for code samples, recommendations for particular components (must be
able to upload directly to the db), etc., but all I've found are
suggestions on uploading to a directory.
Any and all help will be sincerely appreciated.

TIA,

Dani

Nov 13 '05 #1
4 1689

Dani wrote:
Hi,

I'm hoping that some of you will have experience with uploading images via ASP to an Access db on a remote server. I've scoured the threads
for code samples, recommendations for particular components (must be
able to upload directly to the db), etc., but all I've found are
suggestions on uploading to a directory.
Any and all help will be sincerely appreciated.

TIA,

Dani


I'm not sure importing all the images into the database is the best
solution. Is there a specific reason you need to do this? Most people
write the path of the image into the database and then just Use
LoadPicture or whatever to show the image... is there a reason that
won't work for you?

Nov 13 '05 #2
This database will be for clients to log on and view photo proofs, so
mostly my concern is security . My reasoning is that by using a
secured database, I won't have to worry about someone finding my pics
laying around in a directory. (If I'm wrong, or there's a better way,
let me know.)

Thanks for your help,

Dani

P.S. By the way, I've disabled right-clicking via JavaScript, but if
you have any other ideas, I'm all ears. Thanks again.

Nov 13 '05 #3
Ed
Dani wrote:
This database will be for clients to log on and view photo proofs, so
mostly my concern is security . My reasoning is that by using a
secured database, I won't have to worry about someone finding my pics
laying around in a directory. (If I'm wrong, or there's a better way,
let me know.)

Thanks for your help,

Dani

P.S. By the way, I've disabled right-clicking via JavaScript, but if
you have any other ideas, I'm all ears. Thanks again.


Dani,

If you put the photos in a folder outside your web folder (outside of
wwwroot or your virtual directory), then the clients cannot browse to them.

To actually display the images to the clients, you can use an ADO stream
to dynamically read and then write the images to the screen. See:

http://www.aspfaq.com/show.asp?id=2276

for more info.

--

Ed
Nov 13 '05 #4
Thanks! I'll check it out.

Dani

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jon Maz | last post by:
Hi All, To allow myself to make development changes directly on a remote server *without* having to compile on my local dev machine and then upload the dll's to remote, I have created a...
1
by: Ellen12 | last post by:
Ok, the objective of this project is to provide an ARTICLE upload mechanism for PostNuke that will enable us to upload up to 20-40 articles at a time, assign the articles into appropriate topics...
1
by: Rob | last post by:
I'm running a batch file using the Shell function. When I manually launch the batch file, the window remains open, since I use the 'pause' statement. But when I launch the batch file within...
4
by: Bill | last post by:
I need help closing a CMD window when it is executed from Access. 1) The batch file is called from Access. 2) Access closes, 3) the batch runs a copy of the access database (creating a backup)...
3
by: Chris | last post by:
Hi, How can I execute a batch file form asp.net app. I have a form which a user uploads a text file. after the file is uploaded I want a batch file to then execute and do some work. Thanks
12
by: Selva Chinnasamy | last post by:
Hi I am using batch commands against Ms-Access and getting an error Message "Characters found after end of SQL statement." String Here is my sql Dim str_screens As String = "Select * from Screens...
9
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...
0
by: Elroyskimms | last post by:
I need to execute a batch file via ASP.Net. In my VB.Net code, I'm using System.Diagnostics.Process to call the batch file and its appropriate command line arguments. I'm using...
1
benchpolo
by: benchpolo | last post by:
I'm not sure if this is the right section to post my question regarding FTP Batch scripting. Question? I have multiple textfiles where the filename is dynamically changing daily. For example, ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.