Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 198
Search took 1.18 seconds.
Search: Posts Made By: BeeJayEff
Forum: Other Software 09-24-2018, 11:53 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

Thanks, arnelgp, I shall study that when I can find some time
Forum: Other Software 09-24-2018, 07:35 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

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...
Forum: Other Software 09-24-2018, 05:21 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

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...
Forum: Other Software 09-24-2018, 05:15 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

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...
Forum: Other Software 09-24-2018, 01:51 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

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...
Forum: Other Software 09-23-2018, 09:48 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

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...
Forum: Other Software 09-23-2018, 03:52 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Forum: Other Software 09-23-2018, 02:25 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Re: Viewing RAW files in Access - codec ?

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,...
Forum: Other Software 09-23-2018, 12:25 AM
Replies: 22
Views: 610
Posted By BeeJayEff
Viewing RAW files in Access - codec ?

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...
Forum: General 09-20-2018, 05:15 AM
Replies: 14
Views: 361
Posted By BeeJayEff
Re: Limitations

2gb in pbaldy's, 2GB in jdraw's, for example. What is your 1mb - presumably either Mb or MB - but which ?
Forum: General 09-20-2018, 02:29 AM
Replies: 8
Views: 316
Posted By BeeJayEff
Trusted locations

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...
Forum: General 09-20-2018, 01:48 AM
Replies: 14
Views: 361
Posted By BeeJayEff
Re: Limitations

Can I enter a plea for folk to use Mb/MB or Gb/GB correctly, please ? There is nearly an order of magnitude difference.
Forum: Tables 09-14-2018, 02:38 AM
Replies: 14
Views: 299
Posted By BeeJayEff
Re: Indexing

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...
Forum: Tables 09-13-2018, 08:24 AM
Replies: 14
Views: 299
Posted By BeeJayEff
Re: Indexing

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...
Forum: Tables 09-13-2018, 06:15 AM
Replies: 14
Views: 299
Posted By BeeJayEff
Indexing

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...
Forum: Tables 09-06-2018, 09:36 AM
Replies: 31
Views: 777
Posted By BeeJayEff
Re: List of last used tables

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).
Forum: Tables 09-06-2018, 08:45 AM
Replies: 31
Views: 777
Posted By BeeJayEff
Re: List of last used tables

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...
Forum: Theory and practice of database design 08-30-2018, 03:32 PM
Replies: 15
Views: 762
Posted By BeeJayEff
Re: Sudden performance degradation

Yes, as I said above, that is what I have now done.
Forum: Theory and practice of database design 08-30-2018, 11:27 AM
Replies: 15
Views: 762
Posted By BeeJayEff
Re: Sudden performance degradation

OK - I'll try switching if off for the next FE release, and see how both FE and BE grow without C&R.
Forum: Theory and practice of database design 08-30-2018, 11:10 AM
Replies: 15
Views: 762
Posted By BeeJayEff
Re: Sudden performance degradation

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...
Forum: Theory and practice of database design 08-30-2018, 10:51 AM
Replies: 15
Views: 762
Posted By BeeJayEff
Re: Sudden performance degradation

No, my recent changes were only to the FE - and I haven't had to do anything to the FE release to get it all working again. I do have a few instances where a table appears more than once in the...
Forum: Theory and practice of database design 08-29-2018, 11:22 PM
Replies: 15
Views: 762
Posted By BeeJayEff
Re: Sudden performance degradation

Found the problem !

I happened to glance at the relationships diagram and noticed that one of the main tables in the design was duplicated and had lost most of its links to other tables ! Its...
Forum: Theory and practice of database design 08-24-2018, 08:33 AM
Replies: 14
Views: 399
Posted By BeeJayEff
Re: Corruption and Maintainance

OK, I can understand that - thanks. Do you prevent other users from connecting to the BE while you're doing this, and if so, how - a simple maintenance mode flag set and checked maybe ?
Forum: Theory and practice of database design 08-24-2018, 04:53 AM
Replies: 15
Views: 762
Posted By BeeJayEff
Re: Sudden performance degradation

No,no,no - all FEs are run locally, on the user's own machine.
Forum: Theory and practice of database design 08-24-2018, 04:33 AM
Replies: 15
Views: 762
Posted By BeeJayEff
Sudden performance degradation

For the last couple of days, all users have complained of poor system performance.

Background : maximum 6 or 7 users, split FE from BE, persistent connections. C&R on the BE done weekly, usually...
Showing results 1 to 25 of 198

 
Forum Jump



All times are GMT -8. The time now is 07:56 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World