Customer and Product Records not visible in SAGE 50 on one client PC only.

Running Sage 50 Accounts on a network with 10 client PCs. One PC has developed a fault where the Customer and Product records are not shown. Everything else about Sage appears to work okay.
Uninstalled and reinstalled but problem is still there. The Support Info on the Help screen shows 299 Customer records and 125 Product records but no records are displayed. All other client PCs are okay.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael ChisholmCommented:
Have you checked to see if the user permissions in sage are correct.  Have you also tested the user account on another machine to test network security.  This way you can rule out ALC's (access control lists) in sage and on the network.

Once you have completed these tasks post your results and let me know.
Sage50SteveAuthor Commented:
Any user that logs on to Sage on the problem PC gets the same problem. Any user that logs on to Sage on any other PC works okay. So the problem is PC based and not user based. I uninstalled Sage from the problem PC and re-installed it but the problem remains. I replaced SAGE.INI with the one from another PC but again the problem remains. This problem suddenly started last week after years of working okay.
The records for Suppliers, Nominal, Sales Orders etc are all visible and normal, it is only Customer and Product records that are not visible on this PC.
Michael ChisholmCommented:
being PC based has does this system have any other security software like MCAfee running?  I have experienced a similar issue with our timberline and MCAfee blocking network and program files from running properly. It is possible after an update this issue evolved.
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Sage50SteveAuthor Commented:
We have 12 PCs all networked to Microsoft Server 2012. They all have Trend Micro Security Agent installed and this is updated several times per day across all PCs. They are all currently at the same level virus pattern The Sage support info page (HELP> ABOUT) shows identical info on the problem PC as it does on other PCs. 299 Customer Records, 125 Product Records, but nothing is displayed.
Michael ChisholmCommented:
A friend over at sage asked if you can start the program as administrator by right clicking the icon and choosing run as administrator.  Supply the admin credentials if needed and let me know if they are visible.  Or you can log on as administrator and run the same test.

trying to determine if the ACLS are damaged on the system.
Sage50SteveAuthor Commented:
When logged on to Windows as administrator I cannot run Sage - I do not even get the splash screen, instead it complains of "Invalid data path" but it shows the data path G:\SageV16 which is correct!!

If I am logged onto Windows as a normal user I can log on to Sage as a normal user or as MANAGER - but then I cannot see the Customer or Product records......

The User Access Rights for all users look okay and all users work okay on all other PCs.
No users work correctly on the problem PC.
Michael ChisholmCommented:
OK, one other item to try.  Uninstall Sage 50 remove all directories from the system that reference sage such as those stored in the user directory, those stored in programddata, and those stored in the programfiles folders.  If you search sage as an administrator after uninstalling the program you should not find any folders left over. reinstall and test.  This should solve the issue according to the documents on sages support center.  The application may be leaving residual  files or folders in the system after removal.  You can also use revo uninstall after you have completed the regular uninstall but please be careful revo can damage a system.
Bruce DenneySage 50 Consultant and IntegratorCommented:
My only thought is that this could be a permissions issue.

This could have been proven quickly by using run as admin, however, it appears sage is configured to use a mapped drive rather than a unc path, changing to using a unc path would resolve this (and make you ready for V21 where this is needed for full operation).

It may be possible to log on as one of the windows users on a machine that does work and see if it works for them?

The other option would be to reset permissions on the directory and all its contents on the server.
Sage50SteveAuthor Commented:
I did the uninstall and deleted all Sage files and folders, reinstalled but problem remained.
Called Sage and received some limited help but only suggested could be privledges / access rights related.
Then I managed to fix the problem - re-created the user profile for the offending user AND unsync'd the network drive (not sure why it was set to be available offline). One or both of these actions has fixed the problem!!
Thanks for your help anyway.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bruce DenneySage 50 Consultant and IntegratorCommented:
Syncing Sage fileshares is a recipe for disaster.  You end up with 2 incomplete record sets and loads of merge conflicts.

I remember someone doing it with dropbox!

Disable it if you can because it will bite you if users enable it.

The new version internet sync is great if you have users that need to work offline.
Sage50SteveAuthor Commented:
This has fixed the problem.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office Productivity

From novice to tech pro — start learning today.