Web import from Access database

[Ian King]

I know this is an ASP problem, but I don't do asp and I only need to know if
something is possible from ASP.

We supply Clients with an Access database (on CD) for each survey that we
carry out for them. The CD also includes a folder of photographs for the
sample points within the survey. Only the path to the photo is stored in
the database. Note that subsequent surveys can be imported into this
database.

Our client has replicated the structure as a web application, and needs to
import data and photos from subsequent surveys that we do for them.

This functionality works fine in my Access database;

1 Import Survey data

2 Return ID of survey just added

3 Create folder based on new ID number to store photos

4 Loop through folder of photos on CD

5 Copy each to new folder

The web site imports the data from the CD ok, but the people developing the
web application are saying that they are unable to automatically import the
photos from the CD to the new folder on the web, although they have offered
a solution of copying them manually one by one!!

I need to know if the process used in Access described above is possible on
the web, or if there is an alternative solution.

TIA

Ian King

 

[Arvin Meyer [MVP]]

I'm going to guess that you wouldn't want to allow this on the Internet for
security reasons. It should be fine on an intranet over a VPN.

Unless there is a security block, you can certainly import, over http or ftp
protocols, an entire folder of data.

 

[Ian King]

Guess what happens when you guess?

Supposing we do want to use it on the Internet - isn't a secure log-on
system good enough security?

Also, if copying folder contents is possible, is there a site you can
recommend to our client for ASP code samples of this type?

I'm guessing the VB code in my Access database won't be suitable.

'create new folder for photos
NewPhotoFldr = NewFldr & "\Photos"
MkDir NewPhotoFldr

'copy photos to folder
NewFleName = ImpPath & "\Photos\*.*"
FleLoop = Dir(NewFleName)

Do While FleLoop <> ""
FileCopy ImpPath & "\Photos\" & FleLoop, NewFldr & "\Photos\" &
FleLoop
FleLoop = Dir
Loop

Thanks for your response

Ian King

 

[Arvin Meyer [MVP]]

There are tons of sites that offer ASP code and plenty of Microsoft ASP and
ASP.Net newsgroups. I personally, would prefer using a VPN or a Secure
Sockets Layer when using any wide area network for information which is
required to be secure. If the data isn't sensitive, a secure log in should
be enough. Assuming that you have permissions (or really the user has
permissions) your code should be fine for creating the folder and copying
the files. Without permissions, you won't be able to run that code.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com