Applying Template to database converted to accdb from mdb Acc2003 (1 Viewer)

Guillem

Member
Local time
Today, 13:50
Joined
Mar 28, 2020
Messages
32
Tried with w7/64, office2016/32 also work fine...
 

isladogs

MVP / VIP
Local time
Today, 12:50
Joined
Jan 14, 2017
Messages
18,186
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

Member
Local time
Today, 13:50
Joined
Mar 28, 2020
Messages
32
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

MVP / VIP
Local time
Today, 12:50
Joined
Jan 14, 2017
Messages
18,186
Remind me .... what are the specs of your machine?
 

Guillem

Member
Local time
Today, 13:50
Joined
Mar 28, 2020
Messages
32
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

MVP / VIP
Local time
Today, 12:50
Joined
Jan 14, 2017
Messages
18,186
Thanks. Very specific! ;)
I don't have the retail version of Office 2019 but it should be similar to 365 in this respect
 

Guillem

Member
Local time
Today, 13:50
Joined
Mar 28, 2020
Messages
32
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.
 

Users who are viewing this thread

Top Bottom