Very difficult tasks?

[George]

Dear friends, two questions, as follows:

1) I have setup a database (access 2003), where I manage images, sound files
and video files (primary key is the filename (all files are stored into a
single folder, i.e. C:\AllFiles).

I have managed using the database to select some of the files and then using
some code to copy them into a second folder, i.e. C:\SelectedFiles (first all
files are deleted from here and then copy the new files).

The difficult part now: I need to copy/send those files to a different
computer (in another location-via internet). How can I do this? Using some
code? Using VPN, what?

2) A general second question: Does anyone from you have in mind any
software that will allow me to display/show/play files (sound, images, mpeg)
– linked to a database, in order to have a table (access table) showing the
filename, the date and time to begin and end the show.

Any help will be highly appreciated,

Thanking you in advance

GeorgeCY

 

[Wayne-I-M]

2) A general second question: Does anyone from you have in mind any

software that will allow me to display/show/play files (sound, images, mpeg)
– linked to a database, in order to have a table (access table) showing the
filename, the date and time to begin and end the show.

Powerpoint
This works very well with access. Ask in the powerpoint forum for details
of links. The basics are that you need to insert a powerpoint ole into a
form in the access DB. I would not "load on load" - That is run the PP on
load of the form. Put the run on a button or each time someone open the form
the PP will run. Slight irriatateing.

I have not made one of these but I have seen one working - in our company.
Most MS Office applications will work OK with each other.

Oh - your first question. You may be able to do this - I don't know if its
a good idea though. Hyperlinking an entire folder may be a little much for
anything not on a LAN. Not sure your broadband would take this much data.
BUT may be wrong about this.

Good luck

 

[bcap]

If you can establish a VPN connection to the other computer then you can
just copy the files in much the same way as you would copy them locally
(except s-l-o-w-e-r).

If you can't establish a VPN, the usual way for shifting files over the
internet is FTP.

Both approaches can be automated from within Access, but I think you need to
decide your preferred approach first. Setting up a VPN or an FTP server is
outwith the scope of this group.

 

[a a r o n _ k e m p f]

or if you want to use VPN, you should just move to SQL Server and ADP.
you can still use the OLE object types-- and it will work over a VPN.

jet doesn't work over most networks in the real world. Jet wasn't
even designed for multiple users.

 

[bcap]

The question is about copying *windows files*, it's got nothing to do with
any database. Learn to read, ****wit.


or if you want to use VPN, you should just move to SQL Server and ADP.
you can still use the OLE object types-- and it will work over a VPN.

jet doesn't work over most networks in the real world. Jet wasn't
even designed for multiple users.

 

[a a r o n _ k e m p f]

wow.. fascinating

I work with the RIAA lol

2 ...... Look at Windows Media Player 11.0. It will do what you want and it
is programmable. I built an Access application that manages a VERY LARGE
co;;ection of sound files and integrated it with WMP11.0. The application
allows selection of any sound file then builds a playlist of the selected
sound files and finally plays each sound file in the playlist.

Steve