Using Graphics With Access (G!WA) & DB Size Limitations

  • Thread starter Thread starter rfmess
  • Start date Start date
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.
 
I just store the full file path to a pic in a table.
Place an unbound image and a bit of code and...

Hey Presto!

Much easier (and cheaper!)
 
Thanks!

Any problems when you retrieve many records with pictures on continuous forms?

If the control is unbound, do you insert the picture via code? If so, don't you have a problem with continuous forms?

Thanks for the feedback!
 
Must admit, the method I use will not work on continous forms.

Single form or reports only.
 
Any idea, if Microsoft will ever solve the graphics "bloating" problem in the future? Everything works great with continuos forms, etc. when I store the graphics in Access tables.

Currently, to buy time, I am creating archive picture DBs each month and refreshing the current month. Luckly the pictures are primarily needed for current records and records are current typically for the current month only.

I think I might have to follow a process of:

- Creating Multiple MDB picture DBs (maybe based on month)
- adding code to store and access pictures to the DBs based on the month stored on every form and report that contains pictures (approximately) 8 or 10 of each)

Could be a pain in the butt, but my users really like the continuous form technques that I have already developed for display and selection.

Thanks again for the feedback!
 
I am havig the same issue with pictures in continuos forms, please post a solution if you find one. Thanks!
 

Users who are viewing this thread

Back
Top Bottom