3 Replies Latest reply on Jan 11, 2011 9:41 AM by Lee Burrows

    Flash CS5 with MS Access BackEnd?

    WebDBApps Level 1

      Hi All,

       

      I need to create a Flash CS5 solution that queries data from an MS Access database.  Both the Flash application and the database will be located on the same web server and the database will have a specific query for each Flash function.  Is it possible to accomplish this interface between Flash and Access with some ActionScript magic alone?  Or, is there an intermediate step (or several steps) that should be taken to query data from Access and return it to Flash?

       

      Thanks,

      Sid

        • 1. Re: Flash CS5 with MS Access BackEnd?
          Lee Burrows Level 4

          hi

           

          in theory it is possible to talk directly to a database with actionscript but it is very complex.

           

          most people use a server side script which flash communicates with, and the script talks to the database. assuming you are using a windows server, look for tutorials on connecting flash to a SQL database - it is basically the same as connecting to an access db.

           

          one thing to note about access: it can only handle 10 simultaneous connections so its not very good for websites - if possible, use a SQL or mySQL database.

          • 2. Re: Flash CS5 with MS Access BackEnd?
            WebDBApps Level 1

            Lee,

             

            Thanks for your response.  This application will be hosted on a Windows server.  As such, it sounds like ASP.NET will be the best approach to establish a "bridge" between the Flash application and the database, which will be upsized from Access to SQL Server.  Can .fla files be directly embedded into ASP.NET sites?

             

            Thanks,

            Sid

            • 3. Re: Flash CS5 with MS Access BackEnd?
              Lee Burrows Level 4

              hi Sid

               

              fla files themselves aren't placed on webservers - it is the .swf files produced by flash CS3/4/5 that are put on the server and they are embedded into a webpage in the same way as images (although the actual html for a swf is more complex than for an image)

              1 person found this helpful