Jul 23 2019 11:42 PM - edited Jul 23 2019 11:48 PM
Hi there,
First off I am not an Access guy at all. I have been asked to help figure out why an MS Access db that was tolerable in ms access 2007, speed wise, is now really slow in Access 2019 on MS Server 2016 Standard. We have upgraded to office 365 office 2019 and since doing so the performance has nosedived. There are 3 users working off a Windows 2016 Server Standard with remote desktop/terminal server. Everything else seems good to go but this database is driving the staff nuts. If they click a button it can take 60 + seconds to open the field/table. Any thought, suggestions or help is greatly appreciated :)
Jul 24 2019 08:38 AM
Without knowing details about the database it is difficult to advice you about it.
In general I can sugest that converting the database to version 2019 would be something worth trying.
Create a new database in Access 2019 and import everything from your "old" database into your new one. If there are compatibility problems they will be mentioned during the importprocedure.
Greetings,
Marcel