Forum Discussion
OK, thanks for that Mike.
Hi JoanEllen
Based on your screenshot you are not using the server edition. The Library location may have been set to the Public Folder. This can be changed by using Set Library Location under your Start Menu > MYOB.
In one of your earlier posts you mentioned :
Are these usual things you'd find in a log file? I had no other problems at all with any other software on the computer. It's only MYOB that freezes - usually if I type too quickly. Then I have to go into task manager and end Huxley process, then login again. That's a daily occurrence.
The entries in your log file are unusual for a non server edition. I can't tell exactly as it seems only part of the file was included. More importantly you mentioned MYOB is freezing and this is a daily occurrence. If what you are describing (myob reverting to old copy) happens after a crash and MYOB did not close properly, it is possible the transactions you entered etc are not committed to the database because of the crash, and are lost. The company file is not closed properly and remains as it was before. Some things may not be completed until the database connection is properly closed.
You need to identify what is causing the freezing. This is unusual and is either caused by something on your computer in terms of software interfering etc or by a corruption in your file that causes MYOB to freeze. Try running AR2023 as administrator to see if this helps.
You likely need to get someone to either look at your company file or at your computer system. I don't like your chances of any practical help from MYOB with this. Talk to your IT person if you have one. Send me an email if you want contact details for someone who might be able to assist remotely - there would be a fee for this assistance though.
Once you solve this issue, you will likely solve the missing transactions issues as well.
Regards
Gavin
- gavin123452 years agoUltimate User
Hi JoanEllen
Both attached errors indicate some other software is interferring - you need to exclude the folder where the MYOB file is stored from things like server backups (during business hours), anti virus scans, dropbox syncing, onedrive syncing etc.
Regards
Gavin
- gavin123452 years agoUltimate User
Hi JoanEllen
No, I have not heard this from MYOB's IT Dept. My comments and suggestions are based on years of dealing with similar issues. You can see my posts count next to my name above - this does not include the posts MYOB deleted because they thought I was too critical of them or their software.
AR2023 uses a database engine developed by Microsoft. In both of your error logs, this Microsoft engine reports it has encountered this error:
System.Data.SqlServerCe.SqlCeException (0x80004005): Database already opened by a different user. [ Db name = C:\Users\Public\Documents\MYOB\My AccountRight Files\Just Cleaning (Queensland) Pty. Ltd. ATF.myox ]
This is a Microsoft reported error - it is not controlled by MYOB developers. The database engine needs 'exclusive' access to the file, and some other software is not allowing this. Typical examples were mentioned in my earlier email. Without knowing what is running in the background on your system it is difficult to guess.
I am not suggesting you disable your anti virus or other protection software, however this other software needs to be configured to exclude the .myox file from its scans.
I suggest you discuss possible causes and solutions with your IT expert. They will have a better idea of what is causing the interference, as well as how to exclude the .myox file.
Regards
Gavin
- JoanEllen2 years agoExperienced User
Thanks again Gavin and I do appreciate your working on a Saturday.
Yes, it's possible when I installed MYOB PC edition 2022 I chose Public Documents as the default folder possibly because we once had a network in the office and that was the existing file location. So is it advisable to change the file location to MyAccountRight - the usual one for PC edition?
Yes, we have an IT person we can ask but would prefer a MYOB / IT specialist. I've emailed you just now asking you to refer someone.
We crashed again today, so I've included today's log, as well as the 25 April log again.
You should be paid Gavin!
Thanks again.
- JoanEllen2 years agoExperienced User
Thanks Gavin. The only processes that are running that I'm aware of are OUTLOOK (to send invoices), GMail (3 accounts open - I need to do this), and recently since October last year we use COUPA online to upload invoices for a particular customer, but this problem happened before then. I really need to use all of these to do my work.
We don't have a server. It's just standalone desktop.
On the task manager the only icon really is Google Workspace Sync (synced). Have you came across instances where Google syncing interfered with MYOB to the extent that this could cause a lot of data?
Our antivirus is Windows Security, which while it does live scans shouldn't interfere with MYOB. I don't really want to turn this off either.
Can I ask if MYOB's IT Dept told you this? And which items on the report specifically lead them to believe some software was interfering? I'm asking because I know this is the stock standard response to everyone who is losing data and MYOB freezes.
There would be a hullabaloo if Google had been found to be disabling software. I'm trying not to be sceptical here.
Thanks Gavin.
- JoanEllen2 years agoExperienced User
Yes I will thank you Gavin. I appreciate the time and effort you have put into this and I'm very grateful to you for helping to clear away a lot of the confusion. Kudos to you and I'm sorry that your efforts aren't recognised the way they should be. I'll phone the person you recommended and I'll go from there.
Thanks very much once again.
- Celia_B2 years agoMYOB Moderator
Hi JoanEllen
We'll really glad to know that gavin12345 has helped you with the issue. If you need assistance don't hesitate to reach out to us on Community Forum Live chat or send us a private message and we'll be happy to assist you.
Cheers,
Cel
- JoanEllen2 years agoExperienced User
Thanks Celia. I did reach out on community forums but no-one from MYOB helped. Only Gavin12345 helped.
- Celia_B2 years agoMYOB Moderator
Hi JoanEllen
Sorry that you had that experience. And I understand your frustrated but were happy to assist you. Please let us know if you need further assistance. If you would like to provide further feedback you are welcome to do so via Feedback & Complaints channel on the Contact Us page on our website
Please feel free to post again.
Regards,
Cel