"for display on my computer."-- anything above 120 PPI is overkill then- and simply is a "feel good inside" number.
For a computer display, most experts recommend a maximum PPI (pixels per inch) of around 110-140, as going significantly higher may not provide noticeable improvement while potentially increasing the cost of the monitor and not being necessary for typical viewing distances; a good range for most users is considered to be between 90 and 110 PPI.
I always tell users to do what makes them happy.
Greg,
I think you have missed the point here.
It is only the master jpg images that are at 1200ppi.
The Bitmaps are created at whatever size I want to show the images in Access at different zoom factors (fast loading as I explained). My Monitor has 94.423 ppi (I've measured it exactly). So, if I want to show a 1 inch image at actual size on the monitor, I have a Bitmap of 94x94 pixels. If I want an image showing at 4 x zoom, I have a Bitmap of 378x378 pixels. So a ppi of 1200 in the master jpg gives plenty of extra detail to produce the Bitmaps using Photoshop Elements. 600 ppi is not quite enough for very high zoom of small objects.
Nonetheless, whatever Bitmaps are produced, they are all at 94.423 ppi (rounded to neareat pixel).
Obviously, this only works on my current monitor. If I get a different monitor, all the Bitmaps will need re-creating based on the ppi of the new monitor.