Alludo USER to USER Web Board

I use VS for my youth football team. I use the function to automatically split each play from a game or practice into separate clips from which I can assemble into various groupings, (like all pass plays together, all third and short plays, or defensive tackles for loss.) It is pretty time consuming but short of spending $20k for football specific software I don't have a solution. Then I thought about an Access database to which I can attach each video clip with meta data in the record for each play. This would work except the max size of an Access database is 2 GB. I shoot in HD so that wouldn't last more than about 15 minutes. Does anybody else use VS for this? Any ideas on how to create a database to organize things? Thanks.

Hi, rather than embedding the videos in the database, which isn't really
a good idea anyway, can you not just link to the video files from the database. Have your database and then have different folders for the different kinds of play and store the videos there.
I haven't used access in a long time but even using mysql web databases
its common practise to link to images (nevermind videos) rather than embed them into the database.


okee

Exactly. And, the 2 GB file size, as far as I know, is not an Access restriction but a file format one, FAT16 and FAT32 had a 2 GB file size limitation. With WIN98 and FAT32 the limit went up to 4 GB and with XP and the NTFS file system there is no limit.

Still, embedding the videos would bloat the application and make it sluggish. Linking the videos is the way to go I reckon.

As mentioned above you store the videos on your hard drive and the access database contains links to those videos. They are not embedded into the Access database and so it will remain fairly small.

You also need to create the system with two (or more) access databases.
The first is is the "Program" containing your forms, reports, queries and such.
The other database(s) contain all the links and so are in effect datafiles.

With linked tables you are in fact only restricted by the size of your hard drive because you can have several linked access tables spread out over several access databases all controlled by one "program".