R
rfmess
Guest
I'm new at this forum stuff, so bear with me. I have a number of years experience with MS Access and have found this forum helpful. In fact, I purchased Graphics with Access (G!WA) from Universal Software Agency based on a recommendation from this forum.
G!WA reduces the amount of space wasted by MS Access when storing forms. My application was continually reaching the 2 gig limit (after being compacted). G!WA does, in fact, reduce the space considerably.
G!WA is useful for simple applications which display and insert pictures on simple forms and simple reports.
However, after installing G!WA and updating my application to utilize it, I ran into a number of problems. I attempted to utilize G!WA with techniques which I already had included in my system and which the users are very happy. I have a picture table with rows associated with each record in another table in the DB.
Specifically, I have a number of problems:
1. The graphics cannot be displayed on continuous forms using G!WA. My application had already used that technique (without G!WA) on a number forms and it worked fine. With G!WA, the "current" picture is displayed/repeated on every row/record.
2. I could not include the graphics in the detail section of the reports. If any record does not have a picture associated with it a subscript error is encountered in a G!WA module. Since you can not view the module, you can not determine the resolution without assistance from the vendor.
The documentation is minimal and when I tried to get more info on the subject from the vendor, I first waited days for reply (no phone support) for US.
Finally, my contact informed me that you cannot use graphics on continuos form (Again, I had already accomplished this feat without the G!WA software. Also, the report problem was forwarded to technical support (a 5 days ago).
I am including this post for a couple of resons. First, if you are planning on using this software on only the most basic application, save your $130. Second, if anyone has used this software and has a way of solving my problem, please let me know and I will retract all my complaints. Unless I get a response soon from the vendor soon, I will go back to trying to resolve my DB size limitations on my own. I might use separate MDB files for the pictures based on the Month of insertion and then dislay and access them utilizing the same technique.
G!WA reduces the amount of space wasted by MS Access when storing forms. My application was continually reaching the 2 gig limit (after being compacted). G!WA does, in fact, reduce the space considerably.
G!WA is useful for simple applications which display and insert pictures on simple forms and simple reports.
However, after installing G!WA and updating my application to utilize it, I ran into a number of problems. I attempted to utilize G!WA with techniques which I already had included in my system and which the users are very happy. I have a picture table with rows associated with each record in another table in the DB.
Specifically, I have a number of problems:
1. The graphics cannot be displayed on continuous forms using G!WA. My application had already used that technique (without G!WA) on a number forms and it worked fine. With G!WA, the "current" picture is displayed/repeated on every row/record.
2. I could not include the graphics in the detail section of the reports. If any record does not have a picture associated with it a subscript error is encountered in a G!WA module. Since you can not view the module, you can not determine the resolution without assistance from the vendor.
The documentation is minimal and when I tried to get more info on the subject from the vendor, I first waited days for reply (no phone support) for US.
Finally, my contact informed me that you cannot use graphics on continuos form (Again, I had already accomplished this feat without the G!WA software. Also, the report problem was forwarded to technical support (a 5 days ago).
I am including this post for a couple of resons. First, if you are planning on using this software on only the most basic application, save your $130. Second, if anyone has used this software and has a way of solving my problem, please let me know and I will retract all my complaints. Unless I get a response soon from the vendor soon, I will go back to trying to resolve my DB size limitations on my own. I might use separate MDB files for the pictures based on the Month of insertion and then dislay and access them utilizing the same technique.