Bob:
Thanks for the advice. Unfortunately it doesn't seem to be the answer. After making the changes you suggested, the code ran a bit faster (45 secs). The file size still grew the same amount. Compacting on close doesn't help in my situation. My code example is only a small portion of...
When I run the code below in Access 97, it loops thru 16,000+ records and takes about 4 seconds. The mdb file size changes from 1788KB to 1872KB. When I run the exact same code in Access 2000, it takes 60 seconds and the file size balloons from 2364KB to 69,932KB. After compacting, file size...
With the form open in design view, open the properties box. You should find a picture property within the format tab. Type in the complete path to the location of your bitmap file. If this works, you may want to have the picture type property set to embedded ( I believe this saves the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.