Search results

Thanks, arnelgp, I shall study that when I can find some time

Probably a couple of thousand 35 mm slides altogether. I will not be storing any images within the Access db, but on an external drive, so a TB drive or bigger should be fine. I will only convert to jpg if and when I need to (many of them are of little interest and/or poor quality), but I want...

I don't have a problem converting the images - Canon's software is well up to that task. It's viewing the original, preferably on an Access form, that's the issue - but from Ridders' post I take it that that will not be possible.

Aah, I think we might be at cross-purposes. The whole point of a RAW file (CR2 in Canon's case) is to capture the image as seen by the camera's sensor, so a 20 Megapixel sensor (as in the 70D) will result in 20MB data at 8-bit depth per pixel - and it can be up to 24 bits per pixel (one byte...

Colin - I cannot attach a .cr2 file as an upload as it's not a recognised file type, so I have sent one to the email address in your footer. But it's 25MB, so whether it gets through remains to be seen !

I don't have a problem displaying jpgs on Access forms, and I don't have a problem with converting cr2 files to jpgs (I just use the Canon DPP software), but I don't want to have to do that as a separate step for every image. I really just want to get a thumbnail of the cr2 on an Access form...

Yes - no joy.

Web browser control looks promising, though it opens the file in Photos, rather than on the form - which is not the end of the world, but not ideal. Also have to convert the file location to a URI, which will be cumbersome. Having the CR2 file as the control source for a normal image control...

I'm implementing an Access database to catalogue a load of old slides. I know there are other products out there which will do that, but a) I'm too tight to buy anything for this and b) I want the learning experience. One of my main drivers here is that I want to store RAW files only (not...

2gb in pbaldy's, 2GB in jdraw's, for example. What is your 1mb - presumably either Mb or MB - but which ?

I'm in the process of changing the way I distribute the FE of a database to many users. Rather than having them download it every time it's updated, I have created a command script to copy the latest version every time they run it. They only need to copy a shortcut to that script onto their...

Can I enter a plea for folk to use Mb/MB or Gb/GB correctly, please ? There is nearly an order of magnitude difference.

Thanks to all for your contributions - I hadn't expected so much discussion ! The thing is that the suggestion to index these two fields only arose from using the Performance Analyzer - which cannot of course know how frequently the fields are referenced. I am not aware that there is in fact...

Awwww, yes it does but it means I need to put more thought into it ! I suspect that by far the most common search is for (not Sold), followed by (Sold and not Returned), followed by (Sold and Returned). There should be no cases of ((not Sold) and Returned). So I need to look at the frequency...

One of my tables includes a pair of Yes/No fields : [SoldFlag] and [ReturnedFlag]. There are a number of queries which use these flags to search for items which are (Sold) or which are (Sold and not Returned) for example. I am not aware of any performance issues with these queries. Running...

Fair enough - the only time I've seen a database with such a huge number of tables was because it was far from normalised (e.g. one table per month for several years).

I'm intrigued by this and find it hard to countenance the design of such a system. The biggest db I look after only has about 30 tables of which about 10 are fairly static lookup tables - but the relationships diagram is quite complex enough, and it is properly normalised. Is a properly...

Yes, as I said above, that is what I have now done.

OK - I'll try switching if off for the next FE release, and see how both FE and BE grow without C&R.

Very interesting. Presumably you mean on the BE - I'm not at work at the moment, so cannot check whether it is set, but I expect it is. But what does "close" mean for the BE - is it when the last user exits and releases the lock file, or is it only if I'm actively working on it (I'm the only...