Oct 27 2021 04:59 AM
Oct 27 2021 04:59 AM
We have in business and producion Access software. Simultaously users is max 30 and size about 200 to 400 mb. But system crash sometimes ( 2 times a day) and make backup copy. Is there way to test what
happened when system crash? Before crash system slows and size is expanding,.
Oct 27 2021 05:32 AM
Some questions about your system:
Oct 27 2021 12:19 PM
Oct 27 2021 01:50 PM - edited Oct 27 2021 01:54 PM
I hope you mean one frontend for each user on their own workstation.
Are you using a persistent connection to the BE file? If not, I would recommend it
Does the frontend contain any tables e.g. 'temp' tables that are being written to on a regular basis?
Is Compact On close enabled in the FE? If so, disable it
One way you could test what happens before a crash is to test for available connections.
If the number of available connections drops significantly, the FE will slow dramatically and then crash. If that is the cause, you can take remedial action to close objects when not in use
Oct 28 2021 03:37 AM
Each user has own frontend.
We have localnetwork 1 gb to server.
All tables are in server not frontend.
CompactOn Close disabled.
But available connections is intresting. we have lot of queries and reports and users
keep all open.
I try to test but error comes (form and report is copies9
Oct 28 2021 06:57 AM
Oct 29 2021 02:17 AM
Now working and when I test available connections are about 230. Thats not a problem.
What you mean setting recorders to nothing ?
Our system consist two main tables and users update these sometimes 30 users simultaneously,
We use same forms for viewing and editing. All is fine when users amount is about 10.
Oct 29 2021 04:32 AM - edited Oct 29 2021 04:43 AM
Sorry that was a typo caused by autocorrect
It should have been...set recordsets to nothing.
Almost 20 years ago, we added a feature to one of my databases for schools for teachers to record tutor group / class attendance. At that time the BE was in Access. The feature worked well in testing but in practice the database dramatically slowed to a crawl as anything up to 80 users simultaneously tried entering data to the same tables. It also led to crashes and corruption. This was seriously bad news both for users and for the program admins. The feature was withdrawn whilst we moved the BE to SQL Server. It took a while to convert but we never looked back. After that, no more slowdowns or crashes and no more corruption.
Oct 29 2021 06:59 AM - edited Oct 29 2021 07:00 AM
Yes. Access makes an excellent FE for use with a SQL Server BE. Try the Express version. Its free and has a 10GB file size limit
Nov 02 2021 03:15 AM