1. I have 25 GPS devices sending their location as sms. The sms is being received by a GSM modem connected to a laptop. The incoming sms are directed to a MS Access table. I have another table "ENTITY" where each GPS device is assigned a name, like a phonebook. The same MS Assess mdb has a form with google maps embedded. I have created a query to extract DISTINCT sms based on LAST RECEIVED for each GPS device. I want these to be plotted on the map. Also the query should be refreshed every 5 seconds, with a corresponding refresh on the [url removed, login to view] ocx should be used, where I can upload georeferenced Raster Maps. The name assigned to each GPS device should be extracted and placed alongside the icon as a label.
2. I have worked on it, so some codes are available with the sample database.
3. [The administrator removed this message for encouraging communication outside [url removed, login to view], which breaches our Terms and Conditions - Section 13:Communication With Other Users.]