Applying Template to database converted to accdb from mdb Acc2003

[Guillem]

Tried with w7/64, office2016/32 also work fine...

 

[isladogs]

Both examples also worked for me using Access 365 64-bit.
In each case, the only difference was that the SmoothProc button procedure started instantly whereas the FaultyProc button procedure took about 5 seconds to start.

FWIW one of your new references was incorrect. It should have been ActiveX Data Objects 6.1 library not the ActiveX Recordset 6.0 library.
However I agree that the SmoothProc worls fine without both ADO references. The FaultyProc is also fine in database 1 but shows error 2467 in database2

 

[Guillem]

Thanks for testing,
Yes, smoothproc is quicker, because run over a local form, faultyProc() run over the same form but on testControlProp2. Accdb database , a copy of testControlProp1. Only for that purpose, not to be executed.
Maybe the problem resides in my machine... But I wait a test over similar machine before to reinstall....

 

[isladogs]

Remind me .... what are the specs of your machine?

 

[Guillem]

Remind me .... what are the specs of your machine?

Intel Core i7 CPU 870 @ 2.93 GHz 2.94
RAM 4.10 GB
64bits O.S., x64 based processor
OfficeProf Plus 2019 64bits / Access 16.0.12730.20144)32 bits

VM running over ESX 5.5 / i7, 8GbRAM, SSD + SATA disks

 

[isladogs]

Thanks. Very specific!
I don't have the retail version of Office 2019 but it should be similar to 365 in this respect

 

[Guillem]

still looking for time to build a new fresh VM with W10/64 + Access2019/32 to make further test... I will keep the thread informed. thanks.