Unsolved
1 Message
0
1072
7060, slow performance, database query MS Access
I would like to report that i have problem with slow performance when running database query MS Access (about 20 minutes).
My system is an dell optiplex 7060 and running Windows 7 with 8GB RAM.
Do you have any idea how improve the perfomance of MS ACCESS?
speedstep
8 Wizard
8 Wizard
•
47K Posts
0
April 19th, 2019 08:00
First off Windows 7 isn't a server.
Second Access Database should be run on a Share-point Server.
Microsoft no longer recommends creating and using Access web apps in SharePoint.
You can save a database to any SharePoint document library.
For more information, see publishing to Access Services and import from or link data to a SharePoint list.
Either way Dell does not support Microsoft Software on a Desktop being used as a server.
To make a web database available in a web browser, you must publish the database to Access Services – a component of SharePoint Server.
If you have a user account on a SharePoint Server, you can use a web database that is published to that server. You can review and edit data in a web browser, but to make design changes, you must open the web database in Access. After you make design changes, you sync those changes to the server to make them available in a web browser.