This content has been marked as final. Show 3 replies
AFAIK datagrip has a Shockwave package, or at least a web-enabled
version, so it might do want you want if you're wedded to Access. But
this won't help Mac users. You might want to look at Valentina or
another cross-platform solution for Shockwave.
if you want it to be accessible from a server and you have hosting space somewhere then likely you have access to a MySQL database. You need to find an Xtra that will allow you to connect remotely and/or locally... for something like this you can use xmySQL Xtra:
I have used it in the past and it would work well for the situation you describe. I would not use an Access DB if you want to access it from the web.
If you decide to set things up locally only then you can use the free and tiny sqlite: http://staff.dasdeck.de/valentin/xtras/sqlite/
It's rather easy to set up, if you're familiar with setting up databases and if you need to update things you can always create an updater program which would be a better solution to the issue of keeping information up-to-date... either a service that could run in the background as almost all programs do nowadays, or a check that gets done each time the program is run... it could check the version of certain files or you can internally keep track of the version in Director and that would tell you if there's an update the user needs... then it's just a download of new information to the database or a new cast that you can swap out (again, using a free Xtra from Valentin called the castXtra: http://staff.dasdeck.de/valentin/xtras/cast/ ). There's a good deal of possibilities that you can explore.
A while back I wrote a set of matched scripts in lingo/ASP that let you issue an SQL query from shockwave to a remote db and get the record set back as a nested list. The query and results are RC4 encrypted making the communication between app and db reasonably safe. The nice thing about this approach is that it’s free, the downside is that you’ll have to write a ton of error handlers for the possible responses you might get back from the db. Also, if you’re passing any user text data in the query you’ll have to do your own input scrubbing to protect from SQL injection attacks. If you’ve got a budget I’d go with a commercial xtra but I’ll post the scripts if you want them.