MS Access database runs slower on SSD than on Spinning disc

[jeffreylewis]

I have just bought a more modern computer Dell 7050 with 1 terrabyte SSD disk running Windows 10 split into "C" and "D" drives
It has Intel Core i7 @3.50 ghz and 64GB RAM

My 12 year old Dell Prescision had 0.5 terrabyte Spinning disk running Windows 10 split into "C" and "D" drives
32GB RAM and handled MS Access Forms very quickly

The new one is faster with things like Excel Spreadsheets or Word Docs, but is irritatingly slower with MS Access forms
Can any body explain why?

Regards Jeff

 

[Minty]

Have you made the folder the Access database is in a trusted location?

 

[The_Doc_Man]

These are pro-forma questions, but we have to ask...

1. Same version of Access on both machines?
2. Same number of folders in the path between the root folder and the database folder?
3. Have you been "playing" with the Windows feature called "Affinity?"

 

[cheekybuddha]

Also check:
1. Your db is not in a OneDrive syncing folder
2. Whether your anti-virus is interfering

 

[jeffreylewis]

Have you made the folder the Access database is in a trusted location?

Thanks Yes

 

[jeffreylewis]

Windows feature called "Affinity?"

Thanks. No I have not

 

[jeffreylewis]

These are pro-forma questions, but we have to ask...

1. Same version of Access on both machines?
2. Same number of folders in the path between the root folder and the database folder?
3. Have you been "playing" with the Windows feature called "Affinity?"

These are pro-forma questions, but we have to ask...

1. Same version of Access on both machines?
2. Same number of folders in the path between the root folder and the database folder?
3. Have you been "playing" with the Windows feature called "Affinity?"

Thanks Same version
Same number of Folders
No Affinity

 

[CJ_London]

Use task manager to compare memory and cpu usage

 

[The_Doc_Man]

It has Intel Core i7 @3.50 ghz and 64GB RAM

It occurs to me that the Core i7 has a separate model number that you didn't tell us. In the past, I have had a Dell XPS 3800 i7-2600, which was a bangin' machine for its time - 15 years ago give or take. I am now running another 'puter with an i7-14700 - and that separate model number makes a HUGE difference because of thread speed differences. There is also the matter of your video card, which you have of necessity changed when you upgraded your machine. Screen painting depends on it.

However, it is interesting that you suggest speed improvements for Word and Excel but degradation for Access. The major difference between the three has to do with internal locking mechanisms. Both Word and Excel use whole-file locks whereas Access does not. If the file in question is hosted by your new machine, then it isn't network lock traffic that is slowing you down (because in that case the network isn't involved.)

When you open your Access app file, can you open a second window to verify that the lock file exists? What version of Access is this?

Finally, we didn't see an answer regarding whether you have a DB file in a OneDrive folder that is actively set up for real-time syncing. Your 12-year-old system very likely didn't have a OneDrive synch setup because it was only about 5 years old 12 years ago and hadn't accumulated much traction yet. But on a new system, I know for a fact that you get bombarded (for a while) to join the OneDrive bandwagon. I still have to now and then slap it around to shut it up.

 

[jeffreylewis]

Wow that's a comprhensive answer.
There are lock files for both the front and back end.
It's all on the same machine.
Access 2007 I don't want to upgrade as it integrates with Ms Office Oulook
I am not in the OneDrive.
Windows 10 Pro

Thanks for the help
Regards
JEFF

 

[cheekybuddha]

What about anti-virus?

 

[Gasman]

Is your SSD running at 100% active time at all?

 

[jeffreylewis]

I have got this

 

[Gasman]

That looks good, certainly a lot better than mine. However I would expect to see it active even a little, when you have those spikes.

 

[Pat Hartman]

I am not in the OneDrive.

You may not have control over this. MS is insistent on "helping" you with truly stupid things. that cater to rank novices.

1. you didn't answer regarding your virus scanner.
2. obscure but if your new computer doesn't have a default printer defined, that can slow down Access because it checks with the printer for some formatting information.

 

[cheekybuddha]

2. obscure but if your new computer doesn't have a default printer defined, that can slow down Access because it checks with the printer for some formatting information.

Good call.

 

[jeffreylewis]

You may not have control over this. MS is insistent on "helping" you with truly stupid things. that cater to rank novices.

1. you didn't answer regarding your virus scanner.
2. obscure but if your new computer doesn't have a default printer defined, that can slow down Access because it checks with the printer for some formatting information.

Default printer is set.
Virus protection is TotalAV but ist was slow before I put that on the computer

 

[cheekybuddha]

Do you have any reports in your database?

 

[jeffreylewis]

Do you have any reports in your database?

Yes I do, and they open quick enough

 

[cheekybuddha]

Add a new standard module for testing and paste in the following function:

Function ReportPrinters()

  Dim rpt As Object
 
  For Each rpt In CurrentProject.AllReports
    DoCmd.OpenReport rpt.Name, acViewDesign
    Debug.Print rpt.Name, Reports(rpt.Name).Printer.DeviceName
    DoCmd.Close acReport, rpt.Name
  Next rpt
  ReportPrinters = Err = 0
 
End Function

Then, in the Immediate Window (Ctrl+G), type:

?ReportPrinters

and hit return.

Does it list any printers that are not accessible to the new computer?