Search results

Fair enough. That's your opinion but its also your database!

Its in Access Options . . .Current Database Once that is ticked, you can set the Use Theme to Yes or No in the property sheet Format tab for command buttons and some other control types: It will be Yes by default for all new controls but not for existing controls created before setting the...

Just to say that @Imb has now sent me the .MDB version of the General file. Thanks I will now need to go through each module converting all API declarations and related variables to be VBA7 64-bit compatible That may take a while as there are a lot of code modules! Hopefully I will then be able...

@Imb I share the same frustration as everyone else regarding this (and previous) threads To remind you, I am unable to test your simple example as I use 64-bit Access. Back in post #40, you offered to send me by email an MDB version of the General.mde file so I could try it out. However, it now...

@sonic8 Agreed. I've just edited that sentence as in your post and added a link to Karl's article for AFo .

Here is a further update on issues related to the security fix released on 9 Dec: The fix changed the default setting which is now to block queries to external databases. This is the case whether the query was done using a script, from Excel or from Access itself Previously such queries were...

Further to my previous post: The Access team are aware of the issue which was introduced with a security fix on Tues 9 Dec. They are currently investigating for workarounds, and whether a change could be made to allow cases such as yours. In the meantime, they have referenced this older article...

I have already had a response from the Access team. They are aware of the issue which was triggered by a security fix released on Tues 9 Dec. I will give a more detailed response and hopefully a workaround once I have had further confirmation from the team

If it works for you then that's great. I'll let you know if and when I get a response from the A-team

One thing. When the query ran successfully in version 2509, the output in the LINQPad window just showed the number of records (1) but not the actual data. Is that normal? I agree that this is very unusual usage so it may not be a high priority to fix. If not you will indeed need to find a...

Thanks I downloaded the 64-bit version of LINQPad with the following results Using CC version 2511 19426.20186 64-bit, the script failed on the line var rs = .... with the error Operation is not supported for this type of object Using Beta version 2601 19611.20002 64-bit .... same error Rolling...

Hi. For anyone too young (or old) to know where Max Headroom originated, see https://en.wikipedia.org/wiki/Max_Headroom_(TV_series)

Thanks for the sample files. All the queries run successfully from Access in Beta Channel v2601 build 19611.20002 64-bit. I need a bit of help to test your script in LINQPad v5. It downloaded the required NuGet Interop files but when I run your script I get this runtime error: COMException...

I assume you meant versions 2509 and 2510 respectively. It would help if you could supply two simple repro databases and (if necessary) a script as so far none of us can replicate this issue

OK thanks. So 20266 is the minor build info for MEC. In future, please report channel, version and build (both major and minor) as shown in the screenshot. Also bitness where that appears to be relevant. Thanks Out of interest, did you attempt a rollback to the previous working version?

I'm confused by your description of 20266 being the latest current channel release for 365. This is the latest CC version / build Can you show a similar screenshot on your system.

@riktek I've tried your example database and have studied the execution flow sequence. Although your explanation of the sequence of events was very clear, having all the Debug.Print statements was very useful for me to understand what was going on. You've obviously put a lot of work into this...

Following Tom's prompt, I tested this on Beta Channel v2601 build 19608.20000 64-bit. No errors occurred

@nectorch Are you and @nector the same person? If so, why are you using two separate accounts?

OK thanks. My email address is below. All being well, I'll post the file back in the thread as a 64-bit ACCDE